Convert number to timestamp for upload
913698May 2 2012 — edited May 2 2012I am using Oracle SQL Developer 3.0.03. and I am trying to upload an Excel file to an Oracle data table. I am getting an error for the date. The column in the database is a timestamp and I don't know what to put into the date format of the 'Data Load Wizard'. If I use the following format ('dd-mon-yy hh.mi.ss') I get 'GDK-05047: A day of the month must be between 1 and the last day of the month.'
Here is an example of the date in a select query: select to_timestamp('40604.0', 'dd-mon-yy hh.mi.ss') from dual
If you run this query you get: ORA-01847: day of month must be between 1 and last day of month.
I am expecting the result to be: 2-MAR-12 12.00.00.000000000 AM
Do I need to change the date format within the Excel document?