formatting date pulled from mysql 1

[y2k1981]

If I use a query to pull a date from MySQL and then try to format it using PHP, it always displays 1st Jan 1970 (presumably this is day 1 for php?).

Here's what I've got - assuming that $myvar contains a date pulled from MySQL:
echo "Date: ".date('jS F Y', $myvar);

If I replace $myvar with an integer, it displays the appropriate date, so why won't it work with the variable?

 

[Chacalinc]

is $myvar a timestamp or a date format? if the mysql field is a date column you need to use the strtotime() function in order to change the date column to timestamp.

http://cl2.php.net/manual/en/function.date.php

 

[y2k1981]

if the mysql field is a date column you need to use the strtotime() function in order to change the date column to timestamp.


thanks, you've answered my question there. and thanks for the quick response