Re: date problem
| From: | Nick Wilson | Date: | Sun, 28 Apr 2002 13:10:21 +0000 |
| Subject: | Re: date problem | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-94981@lists.php.net to get a copy of this message | ||
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
* and then Richard Emery declared....
> 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
Nice one, cheers Richard.
I didn't know about that mysql function...
- --
Nick Wilson // www.explodingnet.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE8y/S9HpvrrTa6L5oRAs9cAJ4jcd8dukhfdaJIla/irYNvnX2ZRwCgoIhU
WjS6nkU1UM44crfOGWlBxRA=
=RYIM
-----END PGP SIGNATURE-----