Importing diff format date to MySQL

[Sankaranarayanan Mahadevan]

Hi,

I have data in CSV format file which has a date value
in the format 'dd/mm/yy'?
When i used 'Load data...' to import to a MySQL table,
all the fields gets the value from the file except the
date field that contains the date of birth??
is there any way to format and import???

Thanks
Regards
Shankar

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Importing diff format date to MySQL

[Egor Egorov]

Sankaranarayanan,
Friday, October 11, 2002, 7:15:30 AM, you wrote:

SM I have data in CSV format file which has a date value
SM in the format 'dd/mm/yy'?
SM When i used 'Load data...' to import to a MySQL table,
SM all the fields gets the value from the file except the
SM date field that contains the date of birth??
SM is there any way to format and import???

No, you can't.
http://www.mysql.com/doc/en/Using_DATE.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php