Subject | Re: [firebird-support] dateadd usage Q |
---|---|
Author | Helen Borrie |
Post date | 2008-10-20T20:38:26Z |
At 08:13 PM 20/10/2008, you wrote:
a value, then yes.
./heLen
>reading the 2.1 release notes these seem to be correct syntax as partIf period_start and period_end are date variables and period_end has
>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);
a value, then yes.
./heLen