Is anybody aware of a select or PL/SQL expression that I could use that would return the first ‘weekday’ of a Month?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Is anybody aware of a select or PL/SQL expression that I could use that would return the first ‘weekday’ of a Month?
+23Hi
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;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.