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.
There are several FUNCTIONS that convert the two TIMESTAMPS from one to the other,
(see comments in PHP manuals) but I
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
2 matches
Mail list logo
