compare months between date field and system date

[vivien siu]

Hi this is a question for ORACLE database.

I wana know how can you take the difference of days between a Date field in table and the system date where their difference must be 30?

for example the date field value is 8/30/2006 and the system date is 7/31/2006. How do I calculate the difference of days between them?

[vivien siu]

erm... never mind I think I found the solution:

select CUST_WSID from LICENSE WHERE LIC_EXPIRYDATE = TO_DATE(SYSDATE + 90)

[Jeanne Boyarsky]

Thanks for posting the solution so that others who see this thread in the future can benefit.