ORACLE EBS AND BI BY KARTHEEK DACHEPALLI
Thursday, November 1, 2018
SQL to find Monday and Friday of the week of a given date
select next_day (sysdate-7,'FRIDAY') Last_Friday, next_day (sysdate-7, 'MONDAY') Last_Monday from dual;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment