Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getdate() as Default value for smalldatetime
Message
From
09/05/2006 07:51:47
Sergey Berezniker
New York, United States
 
 
To
09/05/2006 03:38:42
Peter Pirker
Frederiksberg, Denmark
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Getdate() as Default value for smalldatetime
Miscellaneous
Thread ID:
01120253
Message ID:
01120279
Views:
28
>I'd like to set the default value for a smalldatetime field as Getdate(), but with zeros in the HH:MM:SS:MS part.
>
DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform