| Subject | Re: [firebird-support] How to add 1 minute to timestamp? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-03-18T03:34:59Z |
At 01:51 AM 18/03/2004 +0000, you wrote:
timestamp_field + (1.00000000/1440)
or
timestamp_field + 0.00006944
or use the AddMinute UDF in fbudf.
heLen
>How can I properly add 1 minute to timestamp field? TriedYup. Don't use integer/integer division.
>timestamp_field + 1/1440 but result is rounded down to 0 minutes. Is
>there a better way? Thanks.
timestamp_field + (1.00000000/1440)
or
timestamp_field + 0.00006944
or use the AddMinute UDF in fbudf.
heLen