Re: Date format in MySQL
| From: | John Krewson | Date: | Mon, 03 Feb 2003 14:32:22 +0000 |
| Subject: | Re: Date format in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25369@lists.php.net to get a copy of this message | ||
strftime()
offers a lot of formatting options for dates.
Hope it helps.
RUBANOWICZ Lisa wrote:
Hi All, I have a date format of YYYY-MM-DD in MySQL and am showing it on a PHP page. However I want to show it as "2 February, 2003" or "2 February" Can someone please help me. The date will not necessarily be todays date (I looked at the datetime() function and the getdate() function but couldn't work it out for these) Thanks for your support All the best Lisa Lisa Rubanowicz CNH Ireland Tel: +353 46 77663 Email: <mailto:lisa.rubanowicz@cnh.com> lisa.rubanowicz@cnh.com-- John Krewson Programmer - SWORPS