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

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

Written By
Problem with DateTime UTC in version 5.0.46
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.