Skip to Main Content

APEX

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!

Timestamp - specifying a format AM and PM

Mr NeilAug 8 2006 — edited Aug 9 2006
All,

I am following this datestamp oriented thread...

1315670

.. and I'm having the same trouble that Laura was having.

A mask of systimestamp,'DD-MON-YYYY HH24:MI:SS.SSSSS' produced the error as shown, "... ORA-01849: hour must be between 1 and 12"

I can change the mask to "...HH12...." to solve that issue but then I can't specify AM or PM.

Any solution will do! Can you help?

FM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2006
Added on Aug 8 2006
10 comments
1,479 views