Thanks to everybody for the help !!!

Best regards,

Nico


--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> Hi,
>
> > At June 29, 2004, 11:26, Nico Callewaert wrote:
> >
> > > Is it possible to minus the 'NOW' constant with 3 months ? I'm
> > > using 'NOW' - 90, but that's not really correct.
> >
> > You can use a UDF. There are some that exists that would do

exactly

> > what you want, but I can't suggest which one that you need, since

I

> > don't know on which OS you need it. Look on www.ibphoenix.com in

the

> > contributed section.
>
> If he is using Firebird 1.5, then there's no need for
> a third-party UDF library. Firebird 1.5 comes with a
> UDF library "fbudf" which includes a function addMonth.
>
>
> --FBUDF_API ISC_TIMESTAMP* addMonth(ISC_TIMESTAMP* v, int nmonths)
> declare external function addMonth
> timestamp, int
> returns timestamp
> entry_point 'addMonth' module_name 'fbudf';
>
> Simply use a negative number for nmonths.
>
>
> HTH,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database and MS SQL Server
> Upscene Productions
> http://www.upscene.com