Menu
Community /Pin to ProfileBookmark
@NogDogAug 21.2009 — #The second argument to date() must be a UNIX timestamp integer. Your query is returning a date string (e.g. "2009-08-20 12:34:56"). You can convert that string to a UNIX timestamp integer via strtotime().
The reason you are getting the date you are seeing is that a UNIX timestamp integer of 0 (zero) is 1970-01-01 00:00:00 GMT. The time you are seeing is based on the date string you are giving it after it is cast to an integer, probably 2009 (the point where the PHP parser sees a non-integer character). 2009 seconds into the "UNIX era" is 1970-01-01 00:33:29 GMT. Presumably your server's locale setting has it in a timezone which is 5 hours behind GMT (e.g. US CDT or US EST), thus the Dec. 31 date/time.
Problem with Date fuction and a mySQL timestamp
I’m trying to format a date to make it a bit more user friendly, but regardless of the timestamp I use, it outputs the same wrong date. Here is part of the line which is giving me issues:
[CODE]date(“j M Y G:i:s”, $row[‘TS’]) .”</td><td>”.$row[‘TS’]
TS is of course my timestamp field retrieved from mySQL. Here is a sample of what I am getting back:
31 Dec 1969 19:33:29 2009-08-20 15:03:36
I actually googled the date yesterday, found a post totally unrelated but had the same TS down to the second. The post said the date I’m getting back is code for an invalid timestamp. I don’t know if that’s true or not.
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogAug 21.2009 — #The second argument to date() must be a UNIX timestamp integer. Your query is returning a date string (e.g. "2009-08-20 12:34:56"). You can convert that string to a UNIX timestamp integer via strtotime().[code=php]
date('j M Y G:i:s', strtotime($row['TS']))
[/code]The reason you are getting the date you are seeing is that a UNIX timestamp integer of 0 (zero) is 1970-01-01 00:00:00 GMT. The time you are seeing is based on the date string you are giving it after it is cast to an integer, probably 2009 (the point where the PHP parser sees a non-integer character). 2009 seconds into the "UNIX era" is 1970-01-01 00:33:29 GMT. Presumably your server's locale setting has it in a timezone which is 5 hours behind GMT (e.g. US CDT or US EST), thus the Dec. 31 date/time.