Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date vs same day last year

706072Jun 10 2009 — edited Jun 10 2009
Hi everybody,

I'm looking for a way to get the same last year's day for a specific date.

I have a table with date's and want in a second column the same day but last year's same day.

Example:
Date: Monday 01 June 2009
Last year Date: Monday 02 June 2008

So it has to be the same day of the same week but 1 year earlier.

Is there a way of doing this?

Thanks for the help?

Erwin.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2009
Added on Jun 10 2009
17 comments
10,998 views