Answers for "oracle sql get date with last day of month"

oracle sql day of month from date

select extract(day from systimestamp) from dual;

Posted by: Guest on October-08-2020

oracle last day of month

-- Last day of current month
SELECT trim(to_date(last_day(sysdate), 'DD/MM/YYYY')) AS LASTDAY FROM DUAL;

Posted by: Guest on April-13-2021

Code answers related to "oracle sql get date with last day of month"