Please read and follow How to use [code] tags and make your code easier to read?
There are three problems here:
'2013-02-1. 12.0 .10.123000000'
'YYYY-MM-DD HH.MI.SS.SSSSSS'
You have more digits in yor string than you have characters in the format mask.
Fixing that, by adding another 3 S's to the end gives:
SQL> SELECT TO_DATE('2013-02-1.12.0. 10. 123000000','YYYY-MM-DD HH.MI.SS.SSSSSSSSS') FROM dual;
SELECT TO_DATE('2013-02-1.12.0. 10. 123000000','YYYY-MM-DD HH.MI.SS.SSSSSSSSS') FROM dual
*
ERROR at line 1:
ORA-01810: format code appears twice
because the format mask code for fractional seconds is not S, it's F. Fixing that gives:
SQL> SELECT TO_DATE('2013-02-1.12.0. 10. 123000000','YYYY-MM-DD HH.MI.SS.FFFFFFFFF') FROM dual;
SELECT TO_DATE('2013-02-1.12.0. 10. 123000000','YYYY-MM-DD HH.MI.SS.FFFFFFFFF') FROM dual
*
ERROR at line 1:
ORA-01821: date format not recognized
Because dates don't hold fractional seconds, only timestamps do. Fixing that (and you only need to FF in the format mask regardless of how many fractional seconds) gives:
SQL> SELECT TO_timestamp('2013-02-1.12.0. 10. 123000000','YYYY-MM-DD HH.MI.SS.FF') FROM dual;
TO_TIMESTAMP('2013-02-1.12.0.10.123000000','YYYY-MM-DDHH.MI.SS.FF')
---------------------------------------------------------------------------
01-FEB-13 12.00.10.123000000 PM
I suggest you read up on date formats in the documentation
] 
Blog
Search
Help
Members
Register
Login
Home
