Subject Re: [firebird-support] dateadd usage Q
Author Helen Borrie
At 08:13 PM 20/10/2008, you wrote:
>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);

If period_start and period_end are date variables and period_end has
a value, then yes.

./heLen