d_dude_2003 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..
>
>
>

Because FB take another approach.

Have a minimum of functions inside and make provisions for the user to
write the required funcionts trougth UDF.

in future FB versions a lot of functions will be incorporated inside the
engine.

Until there use UDF's there are a plenty of libraries available.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br