Use a command line tool to change the date. I am only familiar with perl
and it would be a very short script to change to YYYY-MM-DD.
At 10:48 PM 9/2/2006, David Perron wrote:
I have a pretty large file with a Date column in the format M/D/YYYY.
Is there a way to either change the Date data type in the table or a method
to indicate the date format in the LOAD DATA statement in order to handle
this?
Thanks in advance for any help!
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Chris Jones
14 Oneida Avenue
Toronto, ON M5J 2E3.
Tel. 416-203-7465
Fax. 416-946-1005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]