Yasser Oracle Blog Dive in Oracle with Yasser, Oracle Developer Courses
Pages
(Move to ...)
Home
SQL Fundamentals
SQL Fundamentals II
SQL PLUS
PL/SQL
Forms and Reports
HTML5
JavaScript
PHP
jQuery
Java
NLS_LANG
SQL SERVER
PL/SQL Collections and Records
DBMS_OUTPUT built-in package
Date and Time
PL/SQL Transactions
Ref Cursors
Bulk Binds
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Oracle Courses
PHP
Work Samples
Record & Collection
LOOP
Conditional statements
Triggers
Object Oriented
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
‹
›
Home
View web version
No comments:
Post a Comment