MySQL Timestamp

[Anon]

Hrm... Can anyone tell me why the following MySQL timestamp (20000710173033) give the following date: 18/1/38 with this command: date("j/n/y",$myrow["when"])

I'm lost on this timestamp thing... I'm used to just DATE not the whole thing.

[Anon]

The "date()" function takes on an integer of seconds since 01/01/1969 (I think) as the second parameter. A mysql timestamp won't work. Take a look at mysql's "DATE_FORMAT(...)" function, eg:
SELECT *,DATE_FORMAT(when,'%j/%n/%j') AS newdate FROM whatever...