SQLLDR Import Time string as seconds [message #382659] |
Fri, 23 January 2009 08:43  |
stowelle
Messages: 6 Registered: January 2009 Location: Bristol
|
Junior Member |
|
|
Hi,
I'm currently trying to import a time field using sqlldr. My problem is that in the CSV file my text is in the format "24HH:MM:SS" but I want it to be in the table as a numerical representation of the number of seconds ie if the data value is "10:00:00" then I want it to be imported into the table as the number 36000 with the data type number.
Any help would be much appreciated.
Thanks,
Emma
|
|
|
|
|
Re: SQLLDR Import Time string as seconds [message #382697 is a reply to message #382685] |
Fri, 23 January 2009 10:44   |
stowelle
Messages: 6 Registered: January 2009 Location: Bristol
|
Junior Member |
|
|
Sorry if I sound stupid but I'm not sure what function to write, I've tried using
LOGIN_TIME "TO_NUMBER(TO_DATE(:LOGIN_TIME,'HH24:Mi:SS'))"
but to no avail I get the message invalid number.
The reason I want to do it is because the data is in fact a duration and should not have been stored in this format originally it should have been stored as a number of seconds.
Many thanks for all your help.
|
|
|
|
|
|