OraFAQ Forum: Server Utilities » SQL Loader date mask for the data in the format 02MAR1948:00:00:00.000 OR 24SEP1950:00:00:00.000

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

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21783
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try

DOB TIMESTAMP "DDMONYYYY:HH24:MI:SS.FF3"

Report message to a moderator

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

infinitenumbers
Messages: 33
Registered: November 2010

Member

That works! Thank you so much Smile

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Oct 03 09:45:55 CDT 2023