Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Precision problem???
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Precision problem???
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01596565
Message ID:
01596565
Vues:
87
Hi everybody,

I have strange problem. In SQL Server we have these two datetime values:
2014-03-04 09:30:00.000	2014-03-04 10:00:00.000
In VFP I have the following script

(end_time - start_time)/3600

and compare it with .5

If it's less than .5 it should be true and otherwise it should be false.

So, as we see here, the duration is exactly half an hour and I should get false. But I am getting true and I am not sure why and what may be wrong.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform