Thursday, April 21, 2011

Compare Date in oracle with date time

select * from TableName c
where c. id = 25326424
and c.time_create= to_date('4/21/2011 3:43:24 PM','mm/dd/yyyy:hh:mi:ssam')

No comments:

Post a Comment