SQL query

Hi all 

I need your help, I am not too much expert in SQL, Actually I have to
figure it out one sql query for DB2 data base in AS400 system. 

ODCDAT and ODUDAT are the date fields (MDY format). Sql query should
like that 

Select * from filename where (Current date - ODCDAT) > 2 months and
(Current date - ODUDAT) > 2 months or ODUDAT = blanks) 


your help would be appreciated. 

Thank you in advance.




 

Regards,

Shailendra Kumar

_______________________________________

Software Engineer, GE-GDC ,STC . Hyderabad. 

Ph:040-30633871(Dir) // Mob: 98664-31670

 

 



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.