Subject Re: [ib-support] How to increment TIMESTAMP fields
Author Helen Borrie
At 10:38 AM 09-01-02 +0100, Herbert.Augustiny@... wrote:
>Hi All
>
>How can I incremet a TIMESTAMP field by a number of days, minutes ...
>
>Any hint would be nice.

To add days, increment by 1.
To add minutes, increment by 1/1440...and so on.

cheers,
Helen


All for Open and Open for All
Firebird Open SQL Database ยท http://firebirdsql.org
_______________________________________________________