mysgl, mysql date function Options

[cookie mutza]

can anyone tell me anything about mysqls date functions

[Sparkyg]

Hi There

To display dates from mysql, a couple of funtions I use, just pass in the date in your SQL result, the format can be changed to display any format you like

function ConvFromMySQL2($sqldate) {
$format= "d F Y";
$mydate = date($format,strtotime($sqldate));
return $mydate;
}

function ConvFromMySQL3($sqldate) {
$format= "Y-m-d";
$mydate = date($format,strtotime($sqldate));
return $mydate;
}


to use mysql date functions in mysql just stick them in your query


cheers

Sparky