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