List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 19 2002 4:57pm
Subject:Re: Import Sybase Ase bcp text file with date type format fields
View as plain text  
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
>
>


Thread
Import Sybase Ase bcp text file with date type format fieldsMaurizio Danilo19 Aug
  • Re: Import Sybase Ase bcp text file with date type format fieldsGerald Clark19 Aug
  • Re: Import Sybase Ase bcp text file with date type format fieldsHarald Fuchs20 Aug