Subject Re: [firebird-support] How to add 1 minute to timestamp?
Author Helen Borrie
At 01:51 AM 18/03/2004 +0000, you wrote:
>How can I properly add 1 minute to timestamp field? Tried
>timestamp_field + 1/1440 but result is rounded down to 0 minutes. Is
>there a better way? Thanks.

Yup. Don't use integer/integer division.

timestamp_field + (1.00000000/1440)
timestamp_field + 0.00006944
or use the AddMinute UDF in fbudf.