General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only