Re: Date format in MySQL
| From: | Jeffrey_N_Dyke at Keane dot com | Date: | Mon, 03 Feb 2003 14:35:44 +0000 |
| Subject: | Re: Date format in MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25370@lists.php.net to get a copy of this message | ||
Or if you want to change it when you're pulling out of mysql you can use
the DATE_FORMAT( ) function...
hth
jeff
John Krewson
<krewsonj@sworp To: RUBANOWICZ Lisa <lisa.rubanowicz@cnh.com>
s.utk.edu> cc: "'php-db@lists.php.net'"
<php-db@lists.php.net>
Subject: Re: [PHP-DB] Date format in MySQL
02/03/2003
09:32 AM
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php