I have a problem with a datetime calculation. I am running VFP6.0 (No SP3 yet) I run the following:

create cursor test (START_DT T, END_DT T, CALC_SEC I)
ltStart = {^1999-12-05 08:00}
ltEnd = {^1999-12-05 18:00}
insert into test (START_DT, END_DT, CALC_SEC) VALUES ;
(ltStart, ltEnd, ltEnd -ltStart)
? ltEnd - ltStart
? CALC_SEC

I get a responce of:

36000
35999

Whats the difference between storing the value in a field or just printing it? Ok, 1 seconds not that big of a deal but I spent a few hours trying to figure out why my calculations were off. Do other versions of VFP have this same problem?

-David-