MySql date format problem

[Anon]

I have a table with a colum called 'date' by default it is in the format YYYY-MM-DD

I would like it to be DD-MM-YYYY. I tried to change the Default value (which was 0000-00-00 in the YYYY-MM-DD example to 00-00-0000) but it did not work.

Does anyone know how to configuere the db correctly or knows a different way to change the format ?

regards

ali

[Anon]

I don't now what database you use. I think it might be MySQL and as far as I know you can't change the format in the database.

What you can do is to rearrange the date format before you put the value in and when you take it out from the database.

I think there is some code to do this in the code library here at phpbuilder.com. I think that is where I found the code I am using that I add below.

//From database
/*************************************/
function output_date($string)
{
$stringArray = explode("-", $string);
$date = mktime(0,0,0,$stringArray[1],$stringArray[2],$stringArray[0]);
$convertedDate = date("d-m-Y", $date);
return $convertedDate;

}

//To database
/*************************************/
function input_date($string)
{
$stringArray = explode("-", $string);
$date = mktime(0,0,0,$stringArray[1],$stringArray[0],$stringArray[2]);
$convertedDate = date("Y-m-d", $date);
return $convertedDate;
}

[Anon]

This is much simpler method --

$datetime is stored in the field, something like:

$datetime="$date_from_database";

function reformat_date($datetime)
{
// put date in US format, discard seconds
list( $day, $month, $year, $hour, $min) = split( '[: -]', $datetime );
return "$day/$month/$year  $hour:$min ";
}

BBest regards. zer0Kode.

[Anon]

This is an even simplier method:

$sql = "SELECT DATE_FORMAT( MyDateField, '%d-%m-%Y' ) AS Date FROM MyTable";