Home > IT Answers > Oracle > Oracle Query: Return a date eg 29 February 2008
Csshahie
5 pts.
 Oracle Query: Return a date eg 29 February 2008
Oracle, Query
Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance

Software/Hardware used:
ASKED: April 24, 2008  11:45 AM
UPDATED: May 12, 2008  6:21 PM
RELATED QUESTIONS
Answer Wiki:
to make the year current year, do: last_day(to_date('02/01/' || to_char(sysdate,'yyyy'),'mm/dd/yyyy') ) or select add_months(trunc(sysdate,'yyyy'),2) - 1 from dual;
Last Wiki Answer Submitted:  May 12, 2008  6:21 pm  by  Randym   1,740 pts.
All Answer Wiki Contributors:  Randym   1,740 pts. , Dwaltr   900 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _