Can someone pls help me with the DB2 code how to acheive the following result:

THIS_YEAR LAST_YEAR
--------------------- ---------------------
Wed 10 June 2009 Wed 11 June 2008


I am looking at Same DAY of the last year not the date.

Thanks,
Guru.

Try:

values current date - 1 year + dayofweek(current date) days - dayofweek(current date - 1 year) days

Andy

select dy.DAY_DT TY_DT,
dayname(dy.DAY_DT) as TY_DAY
from PROD_DY dy

Here is the code as of now. Can you please add a column to this statement which will contain the previous year same day. I really appreciate all your help.