RE: timestamp bug increments by one day

2002-10-20 Thread Alan McDonald
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 &g

timestamp bug increments by one day

2002-10-20 Thread Jay X
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: