Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to import from CSV file into INTERVAL DAY TO SECOND column?

Andrei_Iosub-OracleApr 12 2006 — edited Apr 13 2006
Hello,

I need to import data from a csv file that has a column that stores time-intervals (e.g. 2:06:02 Hours:Minutes:Seconds) into a table column INTERVAL DAY TO SECOND.
Does any of you know what format I should apply?

I tried HH:MI:SS but it didn't work.

Any suggestion is welcomed (including changing the column type to something else that might hold time-intervals in it....).

Thanks,
Andrei
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2006
Added on Apr 12 2006
#apex-discussions
9 comments
7,660 views