Re: Comparing TimeStamp field

a little fix to your date conversion -- should be

to_date('21/Dec/2005','dd/MON/yyyy')

and because the column is a timestamp, you need to use

to_timestamp('01/Dec/2005','dd/mon/yyyy')

you should also be aware of how that date will be truncated; if you want to include times from 12:00 AM Dec 1 to Midnight Dec 21, you need to say so:

... between to_timestamp('01/Dec/2005 00:00:01', 'dd/mon/yyyy hh24:mi:ss')
and to_timestamp('21/Dec/2005 23:59:59', 'dd/mon/yyyy hh24:mi:ss') ... Received on Thu Dec 22 2005 - 20:57:51 CST