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)
 Easy Question - Get date and time in field.

Author  Topic 

Dorffius
Starting Member

36 Posts

Posted - 2002-01-18 : 14:54:38
All I want to do is fill a field with the current date and time. How?

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-01-18 : 15:08:43
You almost answered your own question... Use the SQL function getdate(). You can use it in your own INSERT/Update statements, or you can make it a default value on the table, but that only fills it in for inserts.

--------------------------------
There's a new General in town...
Go to Top of Page
   

- Advertisement -