Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SmallDateTime
Message
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Application:
Desktop
Miscellaneous
Thread ID:
01453208
Message ID:
01453260
Views:
39
>>Hi
>>
>>I'm currently using (getdate()) as the default value for my smalldatetime fields, how can I insert a blank date/time as a default instead?
>>
>>Regards
>
>There is no blank date in SQL Server. Use NULL instead (or default date 1/1/1900).

I have seen 1/1/1900 used as a default but have also seen recommendations against the practice. It's a real date. NULL is the way to go IMO.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform