> 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 desire. CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php