quick date question

Lcousins

can someone please explain to me what i am doing wrong in the following bit of code. eventdate is a mysql date field. $testdate always comes out as 31-12-69. (if I echo $row["eventdate"]; I get the correct date but in the standard year-month-day format whereas I want it in the day-month-year format.

thanks

$testdate = date('d-m-Y', $row["eventdate"]);
echo $testdate;

Lcousins

well, actually sort of solved my own problem, would still like to know why the above didnt work but used the following to get round it -

$datetime = $row["eventdate"];
$year = substr($datetime,0,4);
$mon = substr($datetime,5,2);
$day = substr($datetime,8,2);
$testdate = $day."-".$mon."-".$year;
echo $testdate;

jonno946

even easier:


$date = explode("-", $row["eventdate"]);

$new_date = $date[2] . "-" . $date[1] . "-" . $date[0];

iainlang

I'm fairly new around php and mysql, but having fun with them.

What must I do to take your solution the next step and put the date on a web page like, say, 21st March 2006?

TIA.

Iain.

xblue

you may want to look at mysql's date_format function http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html to get the formatting done right within your query.
%D %M %Y should be what you need.