Re: date problem
| From: | Yuri Petro | Date: | Sun, 28 Apr 2002 13:02:20 +0000 |
| Subject: | Re: date problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-94980@lists.php.net to get a copy of this message | ||
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" <nick@explodingnet.com> ???????/???????? ? ???????? ?????????:
news:20020428124818.GA11390@explodingnet.com...
> -----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-----