Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
From 30/12/1899 but what about under?
Message
 
 
À
05/10/2006 00:52:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01159585
Message ID:
01159614
Vues:
18
>Ok, I adjusted all my empty VFP date values to be 30/12/1899 00:00:00. Now, I can have the package to understand that and import the records. But, I have an ancestral tree of martial arts masters in that table so we have birth date going up to the 14th century. So, one of my date is 01/01/1417 00:00:00. And, of course, the package cannot understand that as it is lower than 30/12/1899. What now?

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
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform