How to write a query filter that extracts a single day data for TNPMW
There are obviously many ways to write such query filter, but given the current implementation, there is only one efficient way to do that.
Assuming we have a traffic table T1, with the standard column that contains timestamp 'TSTAMP', and we want data for the entire 1-Jan-2012, this is how it should be written:
|SQL Code||SELECT .... FROM T1
WHERE TSTAMP >= TO_DATE('01-01-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS')
AND TSTAMP < TO_DATE('02-01-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS');