Mensaje
De
08/03/2010 14:48:49
a
08/03/2010 12:13:41
Environment versions
SQL Server:
SQL Server 2005
Application:
Desktop
Miscellaneous
ID de la conversación:
01453208
ID del mensaje:
01453260
Views:
41
>>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.
>>
>>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.