[SOLVED] php date

[Porl123]

Hi people, I'm not sure whether this might be a mysql problem but I'm hoping you can help me anyway. I've got a news page where time stamps are recorded using the NOW() function in mysql, but every time I echo it back it's off completely

 

date('D, d F', $date)

 

is what I'm using to format it and

 

Wed, 31 December

 

is what it returns. Anyone know why? Thanks

[Mchl]

What do you mean by 'it's off completely'? You get different date, than you think you should?

Usual way of getting dates from mysql is

echo date('D, d F', strtotime($dateFromMysql));

[MasterACE14]

or like this...

<?php
$datetime = $row['date'];
$year = substr( $datetime, 0, 4 );
$mon = substr( $datetime, 4, 2 );
$day = substr( $datetime, 6, 2 );
$hour = substr( $datetime, 8, 2 );
$min = substr( $datetime, 10, 2 );
$sec = substr( $datetime, 12, 2 );
$orgdate = date("F j, Y",
mktime( $hour, $min, $sec, $mon, $day, $year ) );

echo $orgdate;
?>

[Porl123]

Ah, that's done it :] thanks guys