I am trying to convert the given String in timestamp format using PL/SQL Language.
Here is the sql query i wrote to convert string in timestamp. But I am getting error "Ora-01810: format code appears twice" while executing the query. Please help me out and let me know what I am doing wrong while executing the query:
select to_timestamp('01/03/2007 12:01:22', 'MM/DD/YYYY HH24:MM:SS') from dual and this one too
select to_timestamp('01/03/2007 12:01:22', 'MM/DD/YYYY HH12:MM:SS') from dual
At the same time I am able to execute the follwoing query:
select to_timestamp('2003/DEC/13 20:13:18', 'YYYY/MONTH/DD HH24:MI:SS') from dual
DO let me know where I am going wrong.
The Best way to predict your future is to create it