Hello Grant,

GB> However now the question is why did FTime = FTime - (3.0/1440.0) not
GB> work ?????
3/1440 means integer division (AFAIR, SQL standard requires such
behavior). 3.0/1440.0 means numeric(?,1)/numeric(?,1) -> numeric(?,2),
so rounding of 0.00208(3) returns 0.00. You could use cast(3 as double
precision)/1440.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com