Message
From
08/03/2010 12:13:41
To
08/03/2010 12:12:50
Environment versions
SQL Server:
SQL Server 2005
Application:
Desktop
Miscellaneous
Thread ID:
01453208
Message ID:
01453210
Views:
59
>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'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).