Home » RDBMS Server » Server Utilities » SQL Loader date mask for the data in the format 02MAR1948:00:00:00.000 OR 24SEP1950:00:00:00.000
SQL Loader date mask for the data in the format 02MAR1948:00:00:00.000 OR 24SEP1950:00:00:00.000 [message #488525] Sat, 08 January 2011 13:32 Go to next message
infinitenumbers
Messages: 33
Registered: November 2010
Member
Hi all,

I am trying to load my data from a CSV file to an oracle table using SQL LOADER. What should be the syntax of DATE MASK for the below kind of data.
02MAR1948:00:00:00.000
24SEP1950:00:00:00.000

I am using the following control file

LOAD DATA
INTO TABLE TW_EXTDATA.PATIENT_VISITS_MERGE_39950
REPLACE
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
PATIENT_ID,
INITIALS,
DOB DATE "DDMMMYYYY:HH:MM:SS.FF"
)

Please help me with this.

Re: SQL Loader date mask for the data in the format 02MAR1948:00:00:00.000 OR 24SEP1950:00:00:00.000 [message #488530 is a reply to message #488525] Sat, 08 January 2011 13:53 Go to previous messageGo to next message
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try
DOB TIMESTAMP "DDMONYYYY:HH24:MI:SS.FF3"
Re: SQL Loader date mask for the data in the format 02MAR1948:00:00:00.000 OR 24SEP1950:00:00:00.000 [message #488531 is a reply to message #488530] Sat, 08 January 2011 14:59 Go to previous message
infinitenumbers
Messages: 33
Registered: November 2010
Member
That works! Thank you so much Smile
Previous Topic: is it safe to kill full db export?
Next Topic: how to export table structure as script in oracle in all schemas
Goto Forum:
  


Current Time: Fri May 24 06:12:45 CDT 2024