Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Simple question on SQL SERVER

Author  Topic  amir Starting Member 12 Posts Posted - 2001-02-20 : 11:25:24 how can I change the default value for date data type to now. I want with every insertion of row to add the current time of the insertion.I tried with now() but it doesn't accept it thank's a lot in advance!