| Subject | Re: [firebird-support] substract just some minutes from a timestamp? |
|---|---|
| Author | Helen Borrie |
| Post date | 2012-09-21T03:32:54Z |
At 02:27 PM 21/09/2012, Roberto Carlos wrote:
select dateadd(minute, -10, current_timestamp) as revised_date from rdb$database;
./heLen
>Firebird 2.5.1See internal function DATEADD(), e.g.,
>
>Select Current_TimeStamp - Cast('00:20:00' as Time) From rdb$database;
>Select Current_TimeStamp - Cast('00:20:00' as TimeStamp) From rdb$database;
>
>Dynamic SQL Error
>expression evaluation not supported
>unknown ISC error 336397244
>How can I correctly substract just some minutes from a timestamp?
select dateadd(minute, -10, current_timestamp) as revised_date from rdb$database;
./heLen