You can include date formatting function in your SQL statement: DATE_FORMAT(date,format) http://www.mysql.com/doc/D/a/Date_and_time_functions.html
-- Kind regards, Yuri. >>>> www.AceHoster.com <<<< Quality web hosting "Nick Wilson" <[EMAIL PROTECTED]> ???????/???????? ? ???????? ?????????: [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi all > I have a field in MySQL db like this: date TIMESTAMP, > and it looks pretty regular like this: 20020428011911 > > when I come to use php date("D M Y", $myTimeStamp) though I get > > TUE JAN 2038! > > I see something in the manual re this date but I'm afraid I still can't > work it out so some advice/help would be greatly appreciated :-) > > - -- > Nick Wilson // www.explodingnet.com > > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.6 (GNU/Linux) > > iD4DBQE8y++SHpvrrTa6L5oRAh3xAJ9lfFdB1VW3KUHCWxnnksN+Uw950QCYpfg6 > OCdApC0Nh/8hi8MYQY3OTQ== > =FnlM > -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php