Perhaps the problem is in your translation. NOW() records a timestamp that
is formated by YYYYMMDDHHMMSS. If you are translating this in PHP a
function designed to take in a UNIX timestamp (that is "Unix Epoch" time ,
the number of seconds from some date 30 years ago) you will recieve a rather
confusing result. This may not be the problem but it was just a thought.
----- Original Message -----
From: "Shane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 10:38 AM
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???
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php