FW: Sqlldr constants and dates w/timestamp
- From: "Marley, Darlene" <dmarley@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 Oct 2004 13:12:31 -0400
-----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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » FW: Sqlldr constants and dates w/timestamp
