Re: What is exact type for informix datatime type in MYSQL

[Devesh Patel]

Hi Kamlesh,
MySQL supports 'datetime' datatype. It stores date (YYYY-MM-DD) and time (HH:MM:SS). If you are converting informix 'datetime year to minute' to MySQL 'datetime', MySQL will store '00' for 'second (SS)' portion of datetime.

For example:
Informix 'datetime year to minute' = 2004-06-29 09:57
will be converted to
MySQL 'datetime' = 2004-06-29 09:57:00

Hope this helps. For more information on MySQL Datetime, please look at http://dev.mysql.com/doc/mysql/en/datetime.html.

Regards,
Devesh

Devesh Patel, Senior Consultant
MySQL Inc.
Get More with MySQL! http://www.mysql.com/consulting