Re: Date format in MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux