Re: [PHP-DB] Dates prior to Dec 31, 1969

2004-12-15 Thread Frank Marousek
Ramil and Jochem, Having mySQL format the date is the best solution... thanks! Frank -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Dates prior to Dec 31, 1969

2004-12-14 Thread Ramil Sagum
On Tue, 14 Dec 2004 15:39:52 -0600, Frank Marousek [EMAIL PROTECTED] wrote: I'm using the following code to display dates returned from a query of a mySQL database. $new_timestamp = strtotime($row_SearchPlayerRcrdSt['Date']); $new_date_formatted = date (m/d/y, $new_timestamp); echo

Re: [PHP-DB] Dates prior to Dec 31, 1969

2004-12-14 Thread Jochem Maas
Frank Marousek wrote: I'm using the following code to display dates returned from a query of a mySQL database. What kind of field is it? (int,timestamp,datetime,etc) $new_timestamp = strtotime($row_SearchPlayerRcrdSt['Date']); what do the following contain: $new_timestamp

[PHP-DB] Dates prior to Dec 31, 1969

2004-12-14 Thread Frank Marousek
I'm using the following code to display dates returned from a query of a mySQL database. $new_timestamp = strtotime($row_SearchPlayerRcrdSt['Date']); $new_date_formatted = date (m/d/y, $new_timestamp); echo $new_date_formatted; It appears that all dates prior to Dec 31, 1969 are displayed as