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!

Convert String to Datetime

596442Dec 19 2007 — edited Dec 19 2007
I have date and time stored as a STRING datatype in this format.
2007-01-01 12:00:01 AM

Now I want all the results greater than some date and time e.g. "2007-09-01 12:00:01 AM" and for that I need to convert the string datatype to DATETIME datatype to make this mathematical expression work. Any help on how can I achieve this or is there any other workaround?

Thanks

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2008
Added on Dec 19 2007
10 comments
138,128 views