Subject | dateadd usage Q |
---|---|
Author | Nick Upson |
Post date | 2008-10-20T10:13:37Z |
reading the 2.1 release notes these seem to be correct syntax as part
of a select
select dateadd(day, -1, CURRENT_TIMESTAMP) from rdb$database;
select dateadd(-1 day to CURRENT_TIMESTAMP) from rdb$database;
but should I be able to have the following within an SP
period_start = dateadd(day, -1, period_end);
period_start = dateadd(-1 day to period_end);
of a select
select dateadd(day, -1, CURRENT_TIMESTAMP) from rdb$database;
select dateadd(-1 day to CURRENT_TIMESTAMP) from rdb$database;
but should I be able to have the following within an SP
period_start = dateadd(day, -1, period_end);
period_start = dateadd(-1 day to period_end);