RE: SQL Date Math

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Yes.

You can consider replacing 365 days with 1 YEAR, if that makes sense in the
greater context of your application.

I suppose you could wrap the derivation into a UDF, passing in CURDATE() as
input.  It would make the code more legible, reusable and maintainable at
the slight cost of UDF call overhead.

Elvis

Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400
http://centerfieldtechnology.com/training.asp
 

-----Original Message-----
Subject: RE: SQL Date Math

Elvis, does it have to go on EACH element of the date (as below)?

select * from bpcs405cdf/frt                                   
where Dec( digits(Dec(year(curdate() - 365 days),4,0)) ||      
          digits(Dec(month(curdate() - 365 days),2,0)) ||

          digits(Dec(day(curdate() - 365 days),2,0)) ) < refdt