Pardeep, Use the GetDate() function and make sure ALLOW NULLS is *not* checked.
HTH, Joseph DeVore VeloxWeb Technologies -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 11:09 PM To: CF-Talk Subject: Re: How do u insert data/time in SQL 2000 In SQL 2000, what code do you type in the default field so that the current date and time is inserted into a field. I have one field for DATE and another for TIME so we know the date and time a form was submitted. Thanks. ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists