First, the timestamp that is retrieved from mysql is NOT the same as is
required for PHP.
Second, do you REALLY wan the Day of the Week (Mon, Tue, Wed) or the date of
the month (1,2,3,4,5,6,...)?
Third, let Mysql do the conversion for you. For instance if you timestamp
field is named "mydate":
SELECT DATE_FORMAT(mydate,"%e %b %Y") AS thedate FROM mytable
----- Original Message -----
From: Nick Wilson <[EMAIL PROTECTED]>
To: php-general <[EMAIL PROTECTED]>
Sent: Sunday, April 28, 2002 7:48 AM
Subject: [PHP] date problem
-----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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
