Oracle Enterprise Solutions & Architecture
Pages
Home
Oracle APEX Change Management System | Yasser Hassan Portfolio
Oracle Change Management System Demo
SQL Fundamentals
SQL Fundamentals II
PHP
SQL PLUS
PL/SQL
Forms and Reports
HTML5
JavaScript
Java
PL/SQL Collections and Records
PL/SQL Transactions
Ref Cursors
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Work Samples
Record & Collection
Conditional statements
LOOP
Triggers
Object Oriented
ِAbout & Consulting
Contact Me
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
Newer Post
Older Post
Home
View mobile version
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment