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