subject:"\[PHP\] mySQL time = year 2038 \[HELP\]"

Re: [PHP] mySQL time = year 2038 [HELP]

2002-07-01 Thread 1LT John W. Holmes

, 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

Re: [PHP] mySQL time = year 2038 [HELP]

2002-07-01 Thread Mirza Muharemagic

Hi Shane, use SYSDATE(). Mirza [EMAIL PROTECTED] 01.07.2002 18:38 > 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 s

Re: [PHP] mySQL time = year 2038 [HELP]

2002-07-01 Thread Kevin Stone

e a rather confusing result. This may not be the problem but it was just a thought. -Kevin - 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

[PHP] mySQL time = year 2038 [HELP]

2002-07-01 Thread Shane

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 clie