View Full Version : Now() Date doesn't seem to work!!

01-22-2007, 01:52 PM
I am using Now() to insert the current date into my date field and everytime it inserts the following value .... 0000-00-00

Anyone help?


01-22-2007, 07:00 PM
Well you haven't shown us your table creation statement, I'll take a guess and say you are assigning a default value of '0000-00-00' which over rides any insert you do on the table.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum