Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
From 30/12/1899 but what about under?
Message
 
 
À
05/10/2006 21:41:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01159585
Message ID:
01159986
Vues:
16
>>In SQL Server unknow dates are usualy represented by NULLs. In MS SQL Server the minimum date that can be stored in the datetime data type is January 1, 1753
>
>Is there something that can be done in our case to support those previous century dates other than to apply a design of additional fields to hold numeric values of those equivalent dates and to apply some kind of logic to extrapolate the related values where required?

Depending on how you use those dates, you can store them either as numbers or as strings.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform