MySQL Forums
Forum List  »  Quality Assurance

Re: Problem with DateTime UTC in version 5.0.46
Posted by: Thomas CORBIERE
Date: October 04, 2007 12:33AM

Hello,

MySQL DateTime format is "YYYY-MM-DD HH:mm:ss".
You may replace any non-digit character by whatever you want,
but the string can't be longer than the expected format.

MySQL doesn't support the concept of timezone for the DateTime format.
If you wish to use timezone, you can use Timestamp instead.
See http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html for more information.

Regards,

Thomas CORBIERE

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem with DateTime UTC in version 5.0.46
4619
October 04, 2007 12:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.