Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

passing date argument to to_date

HeshMay 11 2010 — edited May 12 2010
[ http://www.toadworld.com/Default.aspx?tabid=67&EntryID=536]

I agree there is an implicit conversion of date->text->date, even though this should not happen ?
still don't understand how trunc(sysdate) is greter than same date without timestamp i.e. 12:00:00 ?


THnaks ,
hesh.

Edited by: Hesh on May 10, 2010 10:37 PM
This post has been answered by Roy4321 on May 11 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2010
Added on May 11 2010
7 comments
2,832 views