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!

TO FIND LAST DAY OF THE YEAR

shishuJun 20 2005 — edited Jun 20 2005

I am trying to get last day of the year, is oracle provide any inbuilt function to get this otherwise I am using the below mention query is fine.

select last_day(to_date('01'||'/'||'12'||'/'||to_char(sysdate,'YYYY'),'DD/MM/YYYY')) from dual

Thx
Shishu Paul

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2005

Added on Jun 20 2005

2 comments

1,227 views