Bug #30819 MySQL 5.1
Submitted: 5 Sep 2007 8:24 Modified: 1 Oct 2007 12:10
Reporter: Philip Prabhakar Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: CSV Severity:S3 (Non-critical)
Version:5.1.21 OS:Windows (Dates not converted)
Assigned to: CPU Architecture:Any
Tags: dates

[5 Sep 2007 8:24] Philip Prabhakar 
Description:
Hi

Dates from CSV file when read using Load infile command into CSV engine (CSV table) not capatured.

How to repeat:
8/28/2007,5:23:31,OUT:,Mangos,Tom,10.156.103.18
8/28/2007,5:23:33,IN:,Mangos,Tom,10.156.103.18

Suggested fix:
kindly suggest the date format while reading the file
[5 Sep 2007 8:49] Sveta Smirnova 
Thank you for the report.

Please provide exact version of MySQL server you use.

Also please indicate if you use CSV storage engine or this bug report about wrong behaviour of LOAD DATA INFILE
[11 Sep 2007 13:04] Philip Prabhakar 
Hi.Thnx for the response its MySQL 5.1.21 Version

Method of Loading IniFile

load data infile 'c:\\Test\\flatdata.csv' 
    ->  into table wipdb
    ->  fields terminated by ',';
[11 Sep 2007 13:07] Philip Prabhakar 
Oh Sorry, I just missed out, I have used CSV engine.
[25 Sep 2007 7:12] Sveta Smirnova 
Thank you for the feedback.

Please provide output of SHOW CREATE TABLE wipdb
[1 Oct 2007 12:10] Sergei Golubchik 
This is expected behavior. Read http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html to know what date formats MySQL understands.

(pages http://dev.mysql.com/doc/refman/5.0/en/load-data.html and http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date explain how to solve the problem)