First working day of the Month

Is anybody aware of a select or PL/SQL expression that I could use that would return the first ‘weekday’ of a Month?

Page 1 / 1

Hi @JamesW72

Look at this post, maybe it could helps You

Hi @knepiosko

try this to find the weekday:

Select to_char(trunc(sysdate, 'MM'), 'Day') from dual;

Try this to find the date:

Select trunc(sysdate, 'MM') as "First day" from dual;

Sign up