Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Precision problem???
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Precision problem???
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01596565
Message ID:
01596565
Views:
86
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
Next
Reply
Map
View

Click here to load this message in the networking platform