Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Migrating date fields to datetime
Message
De
28/05/2002 23:15:26
 
 
À
28/05/2002 18:51:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00662090
Message ID:
00662280
Vues:
22
>12/30/1899 is the default date (for blank dates) if you are using VFP databases and VFP ODBC driver. I'm not sure what Oracle, or the other backends that you might connect to use as a default date when blank dates are encountered. You would have to test them.

In my case I found 1/1/1900 to be the default for blank dates for a field that resides in SQL Server (MSDE 7.0) and is read through remote views. A wrinkle is that the field is datetime in the table but date in the view. Does this ring a bell? Where can I find documentation?

Thanks again.

Alex
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform