--- In firebird-support@yahoogroups.com, "d_dude_2003"
<d_dude_2003@y...> wrote:

>
> > So adding a day would be as simple as:
> >
> > Select MyDate + 1
> > From MyTable;
> > From there, you should be able to figure out the rest.
>
> Adding years is not obvious at all. Years can contain different number
> of days and there should be functions to handle that....Why the FB SQL
> is so poor? I remember doing this with MS SQL very easily..
>

Select (MyDate + (365.2525 * :NumOfYears)

This will fail in CE 3000
Come back to me then (or just before) and I'll give a suitable workaround.

mick