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!

ORA-01849: hour must be between 1 and 12

609621May 11 2011 — edited May 11 2011
Dear all,



SELECT SYSDATE FROM DUAL;

returns

11-MAY-2011 17:33:00



SELECT * FROM stables AS OF TIMESTAMP TO_TIMESTAMP ('11-MAY-2011 14:30:00'); returns

ORA-01849: hour must be between 1 and 12

Any idea ?


Kai
This post has been answered by Frank Kulash on May 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2011
Added on May 11 2011
3 comments
56,166 views