formatting dats

irishgirl2004

Hi,
I am putting a date into mysql database, and when i want to display the date it is in the format

yyyy-mm-dd

i want the format

dd-mm-yyyy

can this be done with a php function?

thanks

Drakla

Yup, either use mysql's built in DATE_FORMAT function in your select, or get the date as a unix timestamp with mysql's UNIX_TIMSTAMP(datefield) and then pass it to the php function [man]date/man or pull it out as is, use [man]strtotime[/man] to make it into a timestamp and then pass that to date() - I'd prefer the first method: DATE_FORMAT

irishgirl2004

hi, thanks for this, but seeing as i am doing a select * from the database i'll prob have to use the php functions, i've tried them and made a mess, do you have an example?

thanks

maxpup979

yes. Look at date()
the other thing is a custom function like:

function date_format($indate){
#this assumes the date comes in yyyy-mm-dd and output should be dd-mm-yyyy
$datearray=explode("-",$indate);
#element 0 is year, element 1 is month, element 2 is day
return $datearray[2]."-".$datearray[1]."-".$datearray[0];
}

This should work, but I would still recommend just using date to format it