Results 1 to 2 of 2

Thread: MySQL Date Problem

  1. 06-10-2004, 05:11 AM #1
    Asish
    Asish is offline Registered User
    Join Date
    Jun 2004
    Location
    India
    Posts
    2

    MySQL Date Problem

    Hi all,

    i got a problem in the mySQL date .I tried to fetch the values from the database and stored it in XML file.Actually the value of date field is 0000-00-00 00:00:00 in the table but while i fetch it i'm getting some irregular values like 2-11-30 00:00:00.0.But the other date values are returning correctly.Could anybody help me in this matter?

    Thanks and regards,
    Asish
    Reply With Quote Reply With Quote
  2. 06-13-2004, 10:24 AM #2
    greenman
    greenman is offline Registered User
    Join Date
    Dec 2002
    Location
    Cape Town, South Africa
    Posts
    75
    One of two possible problems really - either the date is being incorrectly inserted into the database, or you're displaying it incorrectly when you return it.

    You'd need to give specifics of your insert and your display code for a more useful answer.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules