Saturday, June 13, 2015

Oracle get date of first monday of the current month

Statement to get date of first monday of the current month :

SELECT NEXT_DAY(TRUNC(SYSDATE, 'MONTH'),'MONDAY') FROM DUAL;

No comments:

Post a Comment