The mysql datetime will have to be
'1999-03-03 12:00:00'
or
19990303120000
Maurizio Danilo wrote:
>Hi,
>
>I have to import some data in Mysql from a Sybase bulk
>copy (bcp) text files, and I have some problems with
>"date" type format fields.
>
>The sybase db has datetime fields and in the
>dump file the date format is like this:
>"Mar 3 1999 12:00:00:000AM"
>
>I have created a table with the same structure but
>when I perform "load data ..." query command Mysql
>import only this '0000-00-00 00:00:00' zero value.
>
>Thanks in advance.
>
>Danilo
>Happy Mysql User
>
>---------------------------------------------------------------------
>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 <mysql-thread117557@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
