Is anybody aware of a select or PL/SQL expression that I could use that would return the first ‘weekday’ of a Month?
Hi
Look at this post, maybe it could helps You
Userlevel 7
+22
Hi
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;
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.