To all who contributed - all responses were meaningful! Thanks! IT
WORKS!
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Friday, November 16, 2007 12:59 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL Date Math
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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
