time stamp

[nikomou]

hello,
i have a mySQL database with a timestamp to record when a user submits a comment.

$Date = $row[date]; 

How can I change this to "Thursday, 21st January 2008"

when used in this case:

echo ("$Date"); 

Thanks for your help!

[BabblingIdjit]

$date_out = date('l jS F Y', $Date); 

more info

[nikomou]

Thanks, I thought that too, but it doesnt work! it keeps using the default date of:

Thursday 1st January 1970

I have no idea why!

Apache version 2.2.9 (Unix)
PHP version 5.2.6
MySQL version 4.1.22-standard

[BabblingIdjit]

That's because $Date contains the value 0.

[nikomou]

nope, because if I

echo ("$Date"); 

i get the value 2008-11-28 09:43:27

[nikomou]

here's the full code:

$Date = $row[date];

$date_out = date('l jS F Y', $Date);

echo ("$date_out");
echo ("$Date"); 

Of which, the output is:

Thursday 1st January 1970
2008-11-28 09:43:27

[thetestingsite]

Use strtotime() to convert the date being returned from the sql query to a unix timestamp and then pass that value to the date function as mentioned before.

Hope this helps.

[BabblingIdjit]

Well

Thursday 1st January 1970
2008-11-28 09:43:27

is NOT a timestamp.