Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SmallDateTime
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Desktop
Divers
Thread ID:
01453208
Message ID:
01453260
Vues:
40
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform