[RESOLVED] Bad Date Formatting

[mrbaseball34]

I am returning a date from my DB and using this to display it:

while($rs = mysql_fetch_object($query)) {
  echo "Game #".$rs->gamenum." - Date: ".
        date('M j, Y', $rs->gamedate)." (".$rs->gamedate.")";
}

It is returning this result:
Game #29 - Date: Dec 31, 1969 (2007-04-21 14:00:00)

Where is the Dec 31, 1969 coming from?
Should be returning Apr 21, 2007.

[mrbaseball34]

DUH!!

date('M j, Y', strtotime($rs->gamedate))

[jkurrle]

Yep, setting the date to a literal text item like "gamedate" effectively sets the timestamp to zero. According to Unix (or is it PHP?) the start of time was January 1st, 1970 at midnight, or somthing close to it...

[Weedpacket]

jkurrle wrote:

Yep, setting the date to a literal text item like "gamedate" effectively sets the timestamp to zero.

In this case the timestamp was set to 2007; or 1970-01-01 00:33:27 GMT.

According to Unix (or is it PHP?) the start of time was January 1st, 1970 at midnight, or somthing close to it...

Unix, and the epoch is exactly 1970-01-01 00:00:00 GMT.