Posted on: 10/17/2012 9:40:36 AM | Views : 432

Hello everyone. I want to record the system date on your computer to the database. Database - in Ms sql server 2000. How can this be done? Tried a couple of options such as
InsertCommand="INSERT INTO Test(CreateDate) VALUES (CONVERT(datetime, CONVERT(varchar, GETDATE(), 101)))" and
InsertCommand="INSERT INTO Test(CreateDate) VALUES (datediff(d, 0, getdate()))"

and

InsertCommand="INSERT INTO Test(CreateDate ...

Go to the complete details ...