> I was just looking at the date/time functions > (http://www.php.net/manual/en/function.time.php) and I can't seem to find > a > function that can format a date that is supplied in the format of a > DATETIME > column. > > So, I was wondering, is there a function that can format it properly or > should I let the database handle the formatting (I'm really new to SQL, I > didn't come across anything to mod in the select statement yet). I could > ofcourse split it on space for a time and a date var and then split the > date > on -'s for years, months and days but efficient is something else I think > :-) In the archives I saw some examples doing exactly that, but nothing > with > a single function (unless home defined ofcourse).
You can use the DATE_FORMAT() function in your SELECT query to format the date however you want it. Or, you can use UNIX_TIMESTAMP() to pull it out in the unix format and then use the PHP function date() to format it. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Date_and_time_functions ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
