FW: Sqlldr constants and dates w/timestamp


-----Original Message-----
From: Marley, Darlene 
Sent: Thursday, October 28, 2004 1:11 PM
To: 'Mercadante, Thomas F'
Subject: RE: Sqlldr constants and dates w/timestamp

Thank you, Thank you, Thank you.  Used the to_date without the CONSTANT
and that did the trick.  You folks are wonderful!

-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx] 
Sent: Thursday, October 28, 2004 12:26 PM
To: Marley, Darlene; oracle-l@xxxxxxxxxxxxx
Subject: RE: Sqlldr constants and dates w/timestamp

Darlene,

Did you try:

deploydatetime  CONSTANT "to_date('04-OCT-2004 14:00:00','dd-MON-yyyy
hh24:mi:ss')",

You can also try this without the "CONSTANT" word.  Should work fine.

Good Luck.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Marley, Darlene [mailto:dmarley@xxxxxxxxx] 
Sent: Thursday, October 28, 2004 12:15 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Sqlldr constants and dates w/timestamp


Maybe someone can save my bloody head from beating it against the wall.
 

I'm using sqlldr 8.1.7 and I'm trying to load a file that needs
supplemental
constant values:

 

OPTIONS(SKIP=3D19)

LOAD DATA

INFILE 'WCA1MESO.csv'

APPEND

INTO TABLE erid.loaddiel

FIELDS TERMINATED BY "," Optionally enclosed by '"' TRAILING NULLCOLS

(

sonde               CONSTANT "33214",

deploydepth     CONSTANT ".64",

retrievaldepth  CONSTANT ".63",

deploydatetime  CONSTANT "04-OCT-2004 14:00:00", -- date format
DD-MON-YYYY
HH24MISS

 

blah, blah,blah

 

I've set my environment variable NLS_DATE_FORMAT to 'DD-MON-YYYY
HH24MISS',
but it still pukes on deploydatetime with the error
"ORA-01830: date format picture ends before converting entire input
string"

 

Any ideas?

 

TIA

Bloody in FL.

 

 

 

I

 


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts:

  • » FW: Sqlldr constants and dates w/timestamp