Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index on Datetime column?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrats & ententes
Divers
Thread ID:
00469678
Message ID:
00470144
Vues:
24
Steve,

You can try anything you want but it won't help because in program code you do not have access to anything beyond the seconds. It is only the value in the dbf that is carried to milliseconds.

As for SQL and anything else, if you are checking for equality as in;
... WHERE MyDateTime = {^2001-01-01 12:00:00} ...
Then you potentially have the problem. However if your code is using a range as in;
... WHERE MyDateTime >= {^2000-01-01 12:00:00} AND ;
          MyDateTime <= {^2000-12-31 23:59:59 ...
Then you won't have the problem.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform