Re: LOAD DATA INFILE date format hell
Sam eproblem here
My csv has date as 01/01/2005, i used
load data local infile 'c:/pet.txt' into table test.test1 FIELDS TERMINATED BY ','(@b)
SET b = str_to_date(@b, '%m/%d/%y');
It gives some warning
Truncated incorrect date value: '11/01/2001
'
but upload data as '2020-01-01'
What coulb be the reason
kapil
Subject
Written By
Posted
February 22, 2007 06:04AM
February 22, 2007 08:16AM
Re: LOAD DATA INFILE date format hell
March 21, 2007 12:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.