Re: mySQL time = year 2038 [HELP]
| From: | 1LT John W. Holmes | Date: | Mon, 01 Jul 2002 19:52:10 +0000 |
| Subject: | Re: mySQL time = year 2038 [HELP] | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-104754@lists.php.net to get a copy of this message | ||
Can you post some example code. I know that 2038 is the maximum for a MySQL
date column, but I don't know how you'd be setting it to that...
---John Holmes...
----- Original Message -----
From: "Shane" <shane@delaplaine.com>
To: <php-general@lists.php.net>
Sent: Monday, July 01, 2002 12:38 PM
Subject: [PHP] mySQL time = year 2038 [HELP]
Checked the archive and saw no difinitives... so... How come when I query my
clients mySQL DB and use NULL or NOW() as my default in a TIMESTAMP record
that it always comes up Jan 18, 2038?
Is the clock not set properly, or am I misunderstanding some basic principal
of the time stamp?
My clients version pf PHP is 4+ on a Windows IIS server.
Any clues???
Thanks
-NorthBayShane
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php