selectTill Next Time
case when
to_number(to_char(to_date('28-FEB-2009'),'d') )
-
to_number(to_char(add_months(to_date('28-FEB-2009'),-12),'d') )= 0
then
add_months(to_date('28-FEB-2009'),-12)
else
next_day(add_months(to_date('28-FEB-2009'),-12), to_number(to_char(to_date('28-FEB-2009'),'d') ))
end as DAY_LAST_YEAR_SAME_WEEK_DAY
from
dual;
Showing posts with label LAST YEAR. Show all posts
Showing posts with label LAST YEAR. Show all posts
Wednesday, November 18, 2009
ORACLE Same weekday last year
How to get the same weekday last year:
Subscribe to:
Posts (Atom)