MySQL Forums
Forum List  »  Quality Assurance

Problem with DateTime UTC in version 5.0.46
Posted by: Rohit Kumar
Date: September 04, 2007 05:53AM

Hi,
I am getting problem when I am trying to insert UTC format('2007-03-31T11:21:25Z') fro the DateTime field with the version 5.0.46.And I can able to insert '2007-03-31T11:21:25'(with out 'Z').

I am execting the query with mysql browser.
Field----- Type -- Null-- Key -- Default -- Extra
field details:'datetimetest'-- 'datetime'- 'NO', 'PRI'--'0000-00-00 00:00:00'- ''
Please direct me what is the problem.

Thank in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with DateTime UTC in version 5.0.46
4917
September 04, 2007 05:53AM


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.