Hi. On Fri 2003-01-31 at 12:17:42 +0100, [EMAIL PROTECTED] wrote: > > I was already questioning my sanity, but the problem below is > reproduceable: > [...] > If I do > mysql> update T_ORDH set STATUS=2 where PK_ID=26272; > ERSTELL_DATUM is set to the current date. I know that a timestamp > takes the current time, if set it to NULL, but since I'm not touching > it, it shouldn't change, should it? [...] > The big question: Is it a bug or a feature?
A feature, it is described in detail in the section that explains the TIMESTAMP column type: http://www.mysql.com/doc/en/DATETIME.html If you don't want that behaviour, use DATETIME with NOW() instead. HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php