Scribd
Upload
8 views

Numeric Functions

Uploaded by

Umesh Kanade
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
8 views

Numeric Functions

Uploaded by

Umesh Kanade
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

SQL> select months_between(sysdate,'30-jul-1993') from dual;

MONTHS_BETWEEN(SYSDATE,'30-JUL-1993')
-------------------------------------
348.54536

SQL> select to_number(months_between(sysdate,'17-nov-1986')/12) from dual;

TO_NUMBER(MONTHS_BETWEEN(SYSDATE,'17-NOV-1986')/12)
---------------------------------------------------
35.7470603

SQL> select trunc(to_number(months_between(sysdate,'17-nov-1986')/12)) from dual


;

TRUNC(TO_NUMBER(MONTHS_BETWEEN(SYSDATE,'17-NOV-1986')/12))
----------------------------------------------------------
35

SQL> select add_months(sysdate,-3) from dual;

ADD_MONTH
---------
15-MAY-22

SQL> select sysdate from dual;

SYSDATE
---------
15-AUG-22

SQL> select least(6,10,13,15,17,70) from dual;

LEAST(6,10,13,15,17,70)
-----------------------
6

SQL> select greatest(6,10,13,15,17,70) from dual;

GREATEST(6,10,13,15,17,70)
--------------------------
70

SQL> select sqrt(6) from dual;

SQRT(6)
----------
2.44948974

SQL> select abs(-106) from dual;

ABS(-106)
----------
106

SQL> select next_day(sysdate,'friday') from dual;

NEXT_DAY(
---------
19-AUG-22

SQL> select last_day(sysdate) from dual;

LAST_DAY(
---------
31-AUG-22

SQL> select last_day('1-feb-2022') from dual;

LAST_DAY(
---------
28-FEB-22

You might also like