Quote:
|
Originally Posted by flyboy
Please, read description of these functions (TO_TIMESTAMP, TO_DATE, TO_CHAR, TRUNC) before using them.
|
They use format masks which are also described in the SQL Reference book.
'PM' is not valid format mask - AM/PM specification is represented by 'AM' mask.
Ready, fire, aim (or trial and error) method is not the best way to develop.
Maybe you shall study the documentation first.