Fbloggs Geekdom

The following PHP code parses the date portion out of a MySQL date column and lets you format it according to the formatting rules of the PHP date function.

// Parse date portion of a date field and format it according to the date() function.
// Second parm is optional.
function FmtDateTime($dt, $fmt = "F d, Y")
{
	$arr = explode("-", substr($dt, 0, 10));
	//	$fmt of "m/d/Y" prints date in mm/dd/yyyy format.
	//  $fmt of "F d, Y" prints date in Spelled out month day, YYYY format

	echo date($fmt, mktime(0,0,0, $arr[1], $arr[2], $arr[0]));
}

To use it, you can do something like this:

<?php
   FmtDateTime($scdDate, "l d F, Y" ); ?>

(This prints 2009-09-15 as “Tuesday 15 September, 2009″).

If you omit the second parameter on the function call, the date will print like this:
“September 15, 2009″

This entry was posted on Tuesday, September 15th, 2009 at 11:35 am and is filed under MySQL, php, Web Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.