Hi.
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......
1094774400

insert into
`mileage`(`start_mileage`,`end_mileage`,`date_of_j ourney`,`reason`)
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:
1094774400

then when I browse the table, the timestamp changes to
20010105054400
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.......

http://www.chriskryzer.net/

any ideas?

thanks.