Date manipulation SQL

[deepatpaul]

I have to create a query that compares dates. For example, (date1 (plus n months)) has to be greater than date2, where n is an integer. How can I do this in ColdFusion? Some variation of the to_date(var) function, or something more involved?

 

[SantaMufasa]

How about:

SELECT ... from ...
WHERE add_months(date1,3) > date2;

...where "3" is the number of months beyond date1?

This should work in both SQL*Plus and Cold Fusion. Let us know.

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:45 (10Aug04) UTC (aka "GMT" and "Zulu"), 09:45 (10Aug04) Mountain Time)

 

[nagornyi]

add_months(date1, :n) > date2

 

[deepatpaul]

Indeed, it does. Thank you so much.