MySQL Forums
Forum List  »  Newbie

DATETIME driving me crazy
Posted by: juergen_simon
Date: May 18, 2005 06:34AM

Hello,

I have a table containing a DATETIME field. Its in table PROCESSINGINFO defined as:

LASTPROCESSINGTIME DATETIME NOT NULL

Now, I want to manually update this field using a query like:

UPDATE PROCESSINGINFO SET LASTPROCESSINGTIME = '2005-01-01 00:00:00';

Query executes. No warnings. No errors.

Result: the datetime field has been changed with a random value, usually in the range of past 3 days or so. Only NOT WITH THE VALUE I WANT IT TO.

I can excercise this with varying date formats, the result is random. This is driving me insane.

Options: ReplyQuote


Subject
Written By
Posted
DATETIME driving me crazy
May 18, 2005 06:34AM


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.