Find the answer to your Linux question:
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 ...
  1. #1
    Linux 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.

    -Mike
    Suse Linux Enterprise Server 11
    Suse Linux Enterprise Server 10 - SP3
    OpenSuse 11.2, KDE 4.3.1

  2. #2
    Linux Guru gogalthorp's Avatar
    Join Date
    Oct 2006
    Location
    West (by God) Virginia
    Posts
    3,105
    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.

  3. #3
    Linux 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
...