isn't that the month changing? it's changing from october to january...?? Alan
> -----Original Message----- > From: Jay X [mailto:sparqz50@;hotmail.com] > Sent: Monday, 21 October 2002 12:20 > To: [EMAIL PROTECTED] > Subject: timestamp bug increments by one day > > > Hi There, > > Just reciently (after no changes) my MySQL database is automatically > incrementing timestamps by one day. > > Timestamp format is timestamp(14). > > An example date would be 20021021143513 > > when I use command such as: > INSERT INTO MyTable SET timestamp = 200210211143513; > > and then: > SELECT * FROM MyTable; > > I get : > > -------------------- > timestamp > -------------------- > 200201221143513 > -------------------- > > This is happening on Redhat 7.1, MySQL Ver 11.15 Distrib 3.23.38, for > pc-linux-gnu (i686) > > when I type: > SELECT NOW(); > > I get the correct date, and when I type: > INSERT INTO MyTable SET timestamp = NOW(); > > that also increments the timestamp by one day just like it does > when I set > the > timestamp manually. > > Thanks, > > Stuart > > > _________________________________________________________________ > Surf the Web without missing calls! Get MSN Broadband. > http://resourcecenter.msn.com/access/plans/freeactivation.asp > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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