MySQL NOW() function in TIMESTAMP field

[Anon]

... parsed by date("m/j/y") is returning 12/31/69 !
I am totally baffled..

I have a timestamp field in my MySQL database and one record, used the NOW() function to insert the current date. On the page i use:

date("m/j/y", $timestamp_from_db);

it returns: "12/31/69". This is interestingly one day before when timestamps are supposed to start from, 1/1/70. I'm running this on a windows machine with IIS, although I think I remember seeing this happen on one of my pages on my UNIX server.

Any ideas??

Thanks

[Anon]

Another one of my records is returning "01/18/38"..

[bretticus]

Are you using MySQL and PHP on the same IIS Server? I guess I'm unclear what you're trying to do. I've messed with TIMESTAMPS in MySQL my fair share, so if you could be more specific, I might could help.

[bretticus]

BTW...

MySQL TIMESTAMP is NOT a UNIX TIMESTAMP.