| Subject | RE: [firebird-support] substract just some minutes from a timestamp? |
|---|---|
| Author | Leyne, Sean |
| Post date | 2012-09-21T02:41:02Z |
Roberto,
Sean
> Firebird 2.5.1Use the ADD_Minute UDF function from the FreeAdhocUDF library (http://freeadhocudf.org/documentation_english/dok_eng_datum.html)
>
> 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?
Sean