Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: int() returning wrong values from datetime operatio
Message
De
13/10/2005 10:14:41
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
13/10/2005 10:01:54
Arlei Silva
Chevron Oronite Brasil Ltda.
Capuava, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Divers
Thread ID:
01058678
Message ID:
01058686
Vues:
32
This message has been marked as the solution to the initial question of the thread.
>Hi all
>
>I have tried it with VFP 6, 7, 8 and 9. All versions returning the same result. Copy and Paste the following code on a new program window and then execute it.
>
>Anyone know what is happening? Or maybe this is just a bug?
>Thank you all
>
>
>
>set date british
>clear
>
>*****************************
>* Sets start and end datetime
>*****************************
>m.T_START = ctot("08/01/2005" + " " + "05:15")
>m.T_END = ctot("08/01/2005" + " " + "05:20")
>
>*****************************************
>* Find and show the difference in seconds
>*****************************************
>m.DIFF_SECONDS = m.T_END - m.T_START
>? m.DIFF_SECONDS					&& Prints 300
>
>*****************************************
>* Find and show the difference in minutes
>*****************************************
>m.DIFF_MINUTES = (m.DIFF_SECONDS / 60)
>? m.DIFF_MINUTES					&& Prints 5,0000
>
>**********************************************************
>* Now the weird thing. Shows the integer of m.DIFF_SECONDS
>**********************************************************
>? int(m.DIFF_MINUTES)					&& Prints 4 (Should be 5, not 4!!!)
>
It's a known thing. Datetime stores milliseconds.
? m.DiffSeconds / 1.000000

m.DIFF_SECONDS = round(m.T_END - m.T_START,0)
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform