Scribd
Upload
27 views

Date Functions

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
27 views

Date Functions

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