Date Format Conversions

[netfrugal]

In my database I enter the date as such: 2007-01-01

I typically follow the YYYY-MM-DD format, as does mysql.

I have to display on a website: mm/dd/yyyy

Does anyone know how to change the date on the fly?

[netfrugal]

I decided to use the substr() function to accomplish this, since it was an easy fix.

$dateCreated = "2007-01-01 12:34:55";

$year =  substr($row['dateCreated'],0,4);
$month =  substr($row['dateCreated'],5,-12);
$day =  substr($row['dateCreated'],8,-9);

$thedate = $month."/".$day."/".$year;

[NogDog]

You could convert it within the query itself by using DATE_FORMAT() function:

SELECT *, DATE_FORMAT(`date_column`, '%m/%d/%Y') AS `formatted_date` FROM `table_name`

Within PHP, you could use [man]strtotime/man with [man]date/man:

echo date('m/d/Y', strtotime($valueFromDB));