[go: up one dir, main page]
Scribd
Upload
44 views2 pages

Date Functions

The document contains SQL queries demonstrating various date functions in Oracle SQL, including SYSDATE, ADD_MONTHS, LAST_DAY, and MONTHS_BETWEEN. It shows how to calculate future dates, find the last day of a month, and determine the number of months between two dates. Additionally, it illustrates how to find the next occurrence of a specific day of the week.

Uploaded by

D. Ancy Sharmila
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
44 views2 pages

Date Functions

The document contains SQL queries demonstrating various date functions in Oracle SQL, including SYSDATE, ADD_MONTHS, LAST_DAY, and MONTHS_BETWEEN. It shows how to calculate future dates, find the last day of a month, and determine the number of months between two dates. Additionally, it illustrates how to find the next occurrence of a specific day of the week.

Uploaded by

D. Ancy Sharmila
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

Current Date

SELECT SYSDATE from dual;

ADD_MONTHS

SELECT ADD_MONTHS('22-AUG-13',3) FROM DUAL;

LAST_DAY(DATE)

SELECT LAST_DAY('22-AUG-13') FROM DUAL;

SQL> select add_months('22-aug-13',2) from dual;

ADD_MONTH
---------
22-OCT-13

SQL> select LAST_DAY('22-aug-13') from dual;

LAST_DAY(
---------
31-AUG-13

SQL> select MONTHS_BETWEEN('22-aug-13','22-AUG-14') from dual;

MONTHS_BETWEEN('22-AUG-13','22-AUG-14')
---------------------------------------
-12

SQL> select MONTHS_BETWEEN('22-aug-14','22-AUG-13') from dual;

MONTHS_BETWEEN('22-AUG-14','22-AUG-13')
---------------------------------------
12

NEXT_DAY(DATE,DAY) GIVE THE NEXT OCCARANCE OF FRIDAY.

SQL> SELECT NEXT_DAY('22-AUG-13','FRI') FROM DUAL;

NEXT_DAY(
---------
23-AUG-13

SQL> SELECT ROUND(SYSDATE,'YEAR') FROM DUAL;

ROUND(SYS
---------
01-JAN-14

SQL> SELECT ROUND(SYSDATE,'MONTH') FROM DUAL;

ROUND(SYS
---------
01-SEP-13

SQL> SELECT ROUND(SYSDATE,'DAY') FROM DUAL;


ROUND(SYS
---------
01-SEP-13

You might also like