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!

How to get the first of jan two years ago?

2896536Sep 21 2015 — edited Sep 21 2015

Hi there forum,

I´d like to dynamically get the date of the 1. january of the year two years ago via SQL.


For example: toda is the 21st of Sept. 2015. I now want to get 01.01.2013. If today would be the 3rd of Jan 2016 I need to get the 01.01.2014.


thanks in advanced
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2015
Added on Sep 21 2015
2 comments
2,120 views