List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:August 25 2006 2:20pm
Subject:Re: MySQL NOW() function producing 0000-00-00 00:00:00
View as plain text  
>> We are using an NOW() function in our database and occasionally it
>> produces odd results. There are entries where it states: 0000-00-00
>> 00:00:00 instead of the current time. Is this a bug, or are we using the
>> function incorrectly?

After patiently injecting at about 400 queries per seconds, a couple of 
hours later, I had about 5 million records in a table.  Not a single one of 
them experienced the above....

I'm pretty sure your 0000-00-00 does not come from NOW()

--
Chris

Thread
MySQL NOW() function producing 0000-00-00 00:00:00Jeremiah Foster25 Aug
  • Re: MySQL NOW() function producing 0000-00-00 00:00:00Renato Golin25 Aug
  • Re: MySQL NOW() function producing 0000-00-00 00:00:00Chris Knipe25 Aug
    • Re: MySQL NOW() function producing 0000-00-00 00:00:00Renato Golin25 Aug
  • Re: MySQL NOW() function producing 0000-00-00 00:00:00Chris Knipe25 Aug
    • Re: MySQL NOW() function producing 0000-00-00 00:00:00Renato Golin25 Aug
    • Re: Re: MySQL NOW() function producing 0000-00-00 00:00:00Dan Buettner25 Aug