...

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



essjay_d12
01-22-2007, 02: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?

thanks

guelphdad
01-22-2007, 08: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