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!

unable to compare date "ORA-01843: not a valid month"

985196Mar 11 2013 — edited Mar 11 2013
Hello All,

I am trying to fire below query but it is failing with error. Please suggest.

SELECT column_name FROM table_name WHERE start_time < '01/01/2011 00:00:00 AM';
ORA-01843: not a valid month

In table the start_time is stored in 2/16/2013 8:31:01 PM format.

Regards,
Ankit

Edited by: 982193 on Mar 11, 2013 6:32 AM
This post has been answered by BluShadow on Mar 11 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2013
Added on Mar 11 2013
3 comments
557 views