Subject | Time Clock |
---|---|
Author | Gordon Hamm |
Post date | 2009-05-28T01:19:15Z |
Ive got 2 fields, both of type Time
Now, I get these value.. respectivly
Time1:=TempQuery2.FieldbyName('Visit1_Time_In').AsDateTime; (val is
Time is 7:00 am)
Time2:=TempQuery2.FieldbyName('Visit1_Time_Out').AsDateTime; (val is
Time is 7:05 am)
Now, I was using a function
HowmanyMinutes:=MinutesBetween(Time2,Time1);
It returned a value of 4 minutes. Weird.
So Then I did
HowManySeconds := SecondsBetween(Time2,Time1);
And found that it returned 299 seconds (Should be 300)
Any ideas why? The value appears right in the database, but its a second off
when doing the math.
Now, I get these value.. respectivly
Time1:=TempQuery2.FieldbyName('Visit1_Time_In').AsDateTime; (val is
Time is 7:00 am)
Time2:=TempQuery2.FieldbyName('Visit1_Time_Out').AsDateTime; (val is
Time is 7:05 am)
Now, I was using a function
HowmanyMinutes:=MinutesBetween(Time2,Time1);
It returned a value of 4 minutes. Weird.
So Then I did
HowManySeconds := SecondsBetween(Time2,Time1);
And found that it returned 299 seconds (Should be 300)
Any ideas why? The value appears right in the database, but its a second off
when doing the math.