DATE FORMATS IN MYSQL

[Anon]

When the date comes back from a select statement in Mysql it arrives

YYYY-MM-DD

and I would like it DD-MM-YYYY

For timestamps it comes as

YYYYMMDDHHMMSS

and again I'd like it

HH:MM DD-MM-YYYY

Is there any nice quick easy way to do this?

Thanks again

Regards

Elizabeth

[Anon]

One method of doing this would be to cut out the stuff you want using substr() and store it in multiple variables or an array and then glue it back together in any form you wanted.

eg. For date

$mysql_date = "20000922";
$year = substr($mysql_date,0,4);
$month = substr($mysql_date,4,2);
$date = substr($mysql_date,6,2);
$my_date = $date."-".$month."-".$year;

Matt

[Anon]

have a look at the mysql DATE_FORMAT() function

--
rad

[Anon]

You can also use the mysql unix_timestamp(datetime|timestamp) function

This has the benefit of working with php date functions very nicely.

[Anon]

Thanks folks!