> 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
