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:
00470401
Vues:
36
>*Set headlightbulb on*
>
>Thanks.
>
>
>>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.

A similar problem to this has existed all along with just plain date variables.

If you were performing a calculation on a date, trying to add some days to it, but you ended up adding a decimal number with a fraction, you'd see two dates that *looked* the same, but didn't compare as being equal. Drove me nuts!
dDate1 = {^2001/01/30} + 1.01    && actually a function call here
dDate2 = {^2001/01/31}

?dDate1        && showed 01/31/2001
?dDate2        && showed 01/31/2001

?dDate1=dDate2 showed .F.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform