Tuesday 19th of January 2038 not my favourite date in mysql - 10-05-2004 , 11:00 AM
I've tried to use mysql with no luck!
all i want to do is enter a date on a web form, save it as a timestamp on a
mysql database, then view it when required in normal fashion!
doesn't sound too hard does it?
the query below was entered, note the timestamp entered......
values(72, 72512, 1094774400, 'company')
all went ok and the following appears to show what went into the table....
INSERT INTO `mileage` ( `start_mileage` , `end_mileage` , `date_of_journey`
, `reason` )
VALUES ( 72, 72512, 1094774400, 'company' )
All is good! note timestamp:
then when I browse the table, the timestamp changes to
which it turns out to be
Tuesday 19th of January 2038.
I understand that this is the final date MySQL is any good until patched,
but why are my entries changing???
after searching google, the following site also gets the same problem on
their news items, lower down the page.......