Database Software

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!

SQL Loader - Load data with HH:MI:SS AM/PM format (without date)

2751250Sep 13 2014 — edited Sep 13 2014

Hi All,

May I have your help?

I tried to load data from CSV file of excel into oracle database 11g using SQL*Loader.

Please advice me how to load time without date format "H:MM:SS AM' to the database.

- What format should I give in the control file?

- How would be the column type of this filed in the table?

Sample data below;

H:MI:SS AM/PM

4:57:08 PM

11:21:45 AM

Thank you in advance.

Ora.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2014

Added on Sep 13 2014

#database-key-features, #export-import-sql-loader-external-tables

1 comment

1,455 views