| Subject | substract just some minutes from a timestamp? |
|---|---|
| Author | Roberto Carlos |
| Post date | 2012-09-21T02:27:08Z |
Firebird 2.5.1
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 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?