Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
From 30/12/1899 but what about under?
Message
De
05/10/2006 10:29:59
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
 
 
À
05/10/2006 00:52:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01159585
Message ID:
01159695
Vues:
14
The birth dates are the 14th century of which calendar? This is the problem with storing dates before 1753. One solution is to store these dates as a number of years before X date. It means another column in your table and that the DTS transformation will have to contain some activex script - or - use a VFP view that splits it up into different columns. You won't be able to perform any datetime arithmetic on these dates, but without the precise calendar information including manual adjustments and leap days, any datetime arithmetic is meaningless.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform