Re: [PHP4BETA] Silly question re formatting dates from a database...

Ryan If you're using MySQL -- then those DOCs are the place to start. MySQL has native functions for handling it's own date types. See section 7.3.11 (approx) for things like DATE_FORMAT(date,format)

     Formats the date value according to the format string.

and select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); HTH Tom Henry At 03:33 PM 3/14/00 -0800, Ryan Robertson wrote:

Ok, so this is a really dumb question. Are there any functions to format a date from a database? I can't find anything obvious in either the string functions or in the date/time functions. Thanks! -- Ryan Robertson Palm Development Support -- PHP 4.0 Beta Mailing List <http://www.php.net/version4/> To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net For additional commands, e-mail: php4beta-help@lists.php.net To contact the list administrators, e-mail: php4beta-admin@lists.php.net

--------------------------------------------------------------------

    Work :-(   http://BusinessWebs.com/
    Home :-)   http://MultihullBoatbuilder.com/

--------------------------------------------------------------------