Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Type default value = Now() 1

Status
Not open for further replies.

FateFirst

Programmer
Apr 15, 2002
212
GB
Is it possible to set the Default value of a field to be the current date/time?

Similar to something like in access where the default value could be: Now().

Thanks :)

- FateFirst
 
Yes, use GETDATE() as default instead.

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.

[ba
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top