> Yep, I was using the DATE() function in PHP to convert a 
 > TIMESTAMP from a MySQL DB query. I was getting a year of 
 > 2038 because MySQL and PHP use different TIMESTAMP formats.

 >      $getmyTime = mysql_query("SELECT UNIX_TIMESTAMP(timestamp_col)
AS yournamehere FROM 
 > myDBnamehere WHERE id = $whatever")
 >       or die("Invalid query");

If you mainly need to output a date in a particular format you might
find it more effective to use mysql's date formatting capabilities.
Have a look in the manual for the section on DATE_FORMAT() which will
let you get the date out of your table in just about any format you

CYA, Dave

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to