oracle last day of month

Solutions on MaxInterview for oracle last day of month by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "oracle last day of month"
Jenna
08 Jul 2018
1-- Oracle: First day of previous year
2SELECT trunc(add_months(sysdate, -12), 'YEAR') FROM DUAL;
Maia
13 Jul 2018
1-- Last day of current month
2SELECT trim(to_date(last_day(sysdate), 'DD/MM/YYYY')) AS LASTDAY FROM DUAL;