Problems using date with MySQL 4.1.0 - Alpha

2003-12-14 Thread Lenny Sorey 
I am currently using MySQL 4.1 Win2K version along ODBC 3.5.1 Driver

I am having trouble using the following LOAD DATA INFILE to import a txt, comma 
delimited file into to a Mysql Table.

Actually the only problem is the date field loading into mysql 4.1.

I have defined the field as a date, datetime and timestamp. 

Where I am having trouble is the date in the second group below. I am receiving the 
information as 
12/06/2003.  All fields load fine with the exception of the 12/06/2003 field.

All I get is is -00-00 00:00:00 for the value of this field.

Can anyone point me to the right direction on how I can successfully load the date 
with the 12/06/2003 format without
getting -00-00 00:00:00 everytime.

Thanks for your help and time.

Lenny Sorey



LOAD DATA INFILE d:/mydir/myfile.Tmp INTO TABLE dealervehicle
FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n';
(CIDLOTD,CVIN,CSTOCKNUM,CDISPOSITI,CMAKE,CMODEL,CYEAR,CMILEAGE,CBODYTYPE,CENGINE,CENGINESIZ,CINDUCTION,CTRANSMISS,
CCOLOR,CPRICE,CCOST,CWARRANTY,CWARRANTYT,FWARRANTY,FWARRANTYT,FWARRANTYC,CPC_LABOR,CPC_PARTS,CWARRMONTH,C
WARRMILES,CMANUF_MON,CMANUF_YEA,CSERVICEAG,DDATE_IN,DDATE_REMO,O1,O2,O3,O4,O5,O6,O7,O8,O9,O10,O11,O12,O13,O14,O15,O1
6,O17,O18,O19,O20,O21,O22,O23,O24,O25,O26,O27,O28,O29,O30,O31,O32,O33,O34,O35);




Dealer Name,2FMZA5145YBC70950,6641,A,FORD,Windstar LX,2000,65969,MINI 
VAN,V-6,3.8,SEQUENTIAL-PORT 
F.I.,AUTOMATIC WITH OVERDRIVE,Red, , ,Y,L,C1, , 
,50,50,90,3000,08,1999,Y,12/06/2003,/  /,POWER 
STEERING,POWER BRAKES,POWER DOOR LOCKS,POWER WINDOWS,AM/FM STEREO 
RADIO,CASSETTE PLAYER,RADIAL 
TIRES,GAUGE CLUSTER,TRIP ODOMETER,TACHOMETER,AIR CONDITIONING,TILT STEERING 
WHEEL,CRUISE 
CONTROL,TINTED GLASS,DRIVER SIDE AIR BAG,PASSENGER SIDE AIR BAG,RECLINING 
SEATS,,ALLOY WHEELS,BODY-SIDE 
MOLDING,LUGGAGE RACK,CLOCK,INTERVAL WIPERS,REAR DEFROSTER,REAR WINDOW 
WIPER,CONSOLE,CARPETING,DAY/NIGHT LEVER,DUAL SPORT MIRRORS,DRIVER SIDE 
REMOTE MIRROR,FRONT BUCKET 
SEATS,CLOTH UPHOLSTERY,THIRD SEAT,CENTER ARM REST,COURTESY LIGHTS







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems using date with MySQL 4.1.0 - Alpha

2003-12-14 Thread Paul DuBois 
At 18:10 -0600 12/14/03, Lenny Sorey wrote:
I am currently using MySQL 4.1 Win2K version along ODBC 3.5.1 Driver

I am having trouble using the following LOAD DATA INFILE to import a 
txt, comma delimited file into to a Mysql Table.

Actually the only problem is the date field loading into mysql 4.1.

I have defined the field as a date, datetime and timestamp.

Where I am having trouble is the date in the second group below. I 
am receiving the information as
12/06/2003.  All fields load fine with the exception of the 
12/06/2003 field.
MySQL expects dates to be formatted in year-month-day order.  If you
check the values that you think loaded successfully, my guess is that you
will find they didn't really.
All I get is is -00-00 00:00:00 for the value of this field.

Can anyone point me to the right direction on how I can successfully 
load the date with the 12/06/2003 format without
getting -00-00 00:00:00 everytime.

Thanks for your help and time.

Lenny Sorey


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]