Thank you for the link about format masks. You might be interested in these ones:
Quote:
SS Second (0-59).
SSSSS Seconds past midnight (0-86399).
FF Fractional seconds. Use a value from 1 to 9 after FF to indicate the number of digits in the fractional seconds. For example, 'FF4'.
|
Can you explain, why you used 'SS.SSSSS'? Instead of the fact it is duplicated, it is also inconsistent (as 02.34.26 PM = 52466 seconds after midnight).
Did you not want to use FF format mask instead? Something like
Code:
SQL> select to_timestamp('17-APR-09 02.34.26.637000000 PM','DD-MON-YY HH12.MI.SS.FF9 PM') from dual;
TO_TIMESTAMP('17-APR-0902.34.26.637000000PM','DD-MON-YYHH12.MI.SS.FF9PM')
---------------------------------------------------------------------------
17-APR-09 02.34.26.637000000 PM
1 row selected.
SQL>