comparing date format having hh:mm:ss:pm
SmileOct 21 2010 — edited Oct 21 2010Hi
In table the records are stored in this format
6/15/2010 1:20:12 PM (mm/dd/yyyy hh:mm:ss PM/AM)
I need to get the records having the date greater than 6/1/2008 00:00:00 AM
How can i get that
I tried the following trunc (dt)>= to_date('06/01/2008','mm/dd/yyyy' )
Please correct me in this query