date_format() help

[dflow]

iwant this format

dd-mm-yyyy

 

i have a DATETIME var  set to DATETIME type  in the DB

<?php echo date_format($row['DATETIME'],'%m-%d-%Y') ?>

ERROR:

 

Warning: date_format() expects parameter 1 to be DateTime, string given on line 510

[kenrbnsn]

The DateTime format that the error message mentions is not the same as the DATETIME column type in MySQL. The manual page for the date_format function points you to the manual page for DateTime::format which tells you what it's looking for:

<?php
$date = date_create($row['DATETIME']);
echo date_format($date,'m-d-Y');
?>

 

Ken

[denno020]

The DateTime format that the error message mentions is not the same as the DATETIME column type in MySQL. The manual page for the date_format function points you to the manual page for DateTime::format which tells you what it's looking for:

<?php
$date = date_create($row['DATETIME']);
echo date_format($date,'m-d-Y');
?>

 

Ken

 

Thanks mate, you've just helped me out heaps here .

[dflow]

thanks a lot