top of page

SQL query between dates

To query a date column between specific dates, use below query

select count(*) from DW.TB_PCDWH0091_FCT_PROJ_DTL
 where dw_load_dt between 
to_date('2016-09-01', 'YYYY-MM-DD HH24:MI:SS') and
to_date('2016-10-31', 'YYYY-MM-DD HH24:MI:SS'); 

Related Posts

Heading 2

Add paragraph text. Click “Edit Text” to customize this theme across your site. You can update and reuse text themes.

bottom of page