Results 1 to 3 of 3
Does anyone know why a blank date from a mysql date field shows up in a php application differently on two different SUSE OS's? The blank date shows as follows ...
- 05-24-2009 #1Linux Newbie
- Join Date
- Feb 2007
- Location
- USA
- Posts
- 221
Blank Dates Differ on SUSE
Does anyone know why a blank date from a mysql date field shows up in a php application differently on two different SUSE OS's? The blank date shows as follows on each machine:
"1969-12-31" - SLES10-SP2 ( php 5.2.5, mysql 5.0.26)
"-0001-11-30" - OpenSUSE11.1 (php 5.2.9, mysql 5.0.67)
I understand that "1969-12-31" is the UNIX time stamp. But what is "-0001-11-30"?
Both machines are 64 bit. My production box is SLES10-SP2 and my development box is OpenSUSE11.1
Thanks.
-MikeSuse Linux Enterprise Server 11
Suse Linux Enterprise Server 10 - SP3
OpenSuse 11.2, KDE 4.3.1
- 05-24-2009 #2
You are running different versions of mysql. This could be a bug in 5.0.67. At least it is more likely then the difference in OS's.
- 05-25-2009 #3Linux Newbie
- Join Date
- Feb 2007
- Location
- USA
- Posts
- 221
Thanks gogalthorp!
Suse Linux Enterprise Server 11
Suse Linux Enterprise Server 10 - SP3
OpenSuse 11.2, KDE 4.3.1


Reply With Quote