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');