Re: Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Dan Buettner
CTED]> Cc: <[EMAIL PROTECTED]>; Sent: Friday, August 25, 2006 4:30 PM Subject: Re: MySQL NOW() function producing -00-00 00:00:00 > Chris Knipe wrote: >> After patiently injecting at about 400 queries per seconds, a couple of >> hours later, I had about 5 million r

Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Renato Golin
Chris Knipe wrote: Doh.. Wrong email ;) INSERT INTO a VALUES (NOW()) ? Sorry, it was not for you, I wanted Jeremiah's query... replied the wrong mail... my fault! ;) --renato -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Chris Knipe
Doh.. Wrong email ;) INSERT INTO a VALUES (NOW()) ? Regards, Chris. - Original Message - From: "Renato Golin" <[EMAIL PROTECTED]> To: "Chris Knipe" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; Sent: Friday, August 25, 2006 4:30 PM Subject: Re:

Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Renato Golin
Chris Knipe wrote: 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 It's one every 5 million and 1 entries... try again ;) Also, maybe (very improbable) it can be

Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Chris Knipe
We are using an NOW() function in our database and occasionally it produces odd results. There are entries where it states: -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 coup

Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Renato Golin
Jeremiah Foster wrote: Hello all, We are using an NOW() function in our database and occasionally it produces odd results. There are entries where it states: -00-00 00:00:00 instead of the current time. Is this a bug, or are we using the function incorrectly? MySQL version info: mysql Ver