Oracle cosh exp Floor in log functions

21. Returns a digital inverse cosine value

Sql> select cosh from dual;

COSH (20)

---------

242582598

22.EXP

Returns the n-th square root of a number E

Sql> Select exp (2), exp (1) from dual;

EXP (2) exp (1)

--------- ---------

7.3890561 2.7182818

23.FLOOR

Take an integer for a given number

Sql> Select Floor (2345.67) from dual;

FLOOR (2345.67)

--------------

2345

24.LN

Returns the numeric value of a number

sql> Select ln (1), ln (2), ln (2.7182818) from dual;

ln (1) ln (2) ln (2.7182818)

--------- --------- -------------

0.69314718.99999999

25.LOG (N1,N2)

Returns the logarithm of a N1-base N2

Sql> Select Log (2,1), log (2,4) from dual;

Log (2,1) log (2,4)

--------- ---------

1 S

26.MOD (N1,N2)

Returns a N1 divided by the remainder of the N2

Sql> Select mod (10,3), mod (3,3), mod (2,3) from dual;

MoD (10,3) mod (3,3) mod (2,3)

--------- --------- ---------

1 0 2

27.POWER

Returns the N2 root of the N1

Sql> Select Power (2,10), Power (3,3) from dual;

Power (2,10) power (3,3)

----------- ----------

1024 27

28.ROUND and Trunc

Rounding according to the specified precision

Sql> Select Round (55.5), round ( -55.4), trunc (55.5), Trunc ( -55.5) from dual;

ROUND (55.5) ROUND ( -55.4) TRUNC (55.5) TRUNC (-55.5)

----------- ------------ ----------- ------------

56-55 55-55

29.SIGN takes the number n symbol, greater than 0 returns 1, less than 0 returns-1, equals 0 returns 0 sql> Select sign (123), sign ( -100), sign (0) from dual;

SIGN (123) SIGN ( -100) SIGN (0)

--------- ---------- ---------

1-1 0

30.SIN

Returns the sine value of a number

sql> Select sin (1.57079) from dual;

SIN (1.57079)

------------

1

31.SIGH

Returns the value of a hyperbolic sine

sql> Select sin (sinh) from dual;

SIN SINH (20)

--------- ---------

.91294525 242582598

32.SQRT

Returns the root of the number n

Sql> Select sqrt (), sqrt (a) from dual;

SQRT (SQRT) (10)

--------- ---------

8 3.1622777

33.TAN

Returns the tangent value of a number

Sql> Select Tan (m), Tan (a) from dual;

Tan Tan (10)

--------- ---------

2.2371609.64836083

34.TANH

Returns the hyperbolic tangent of a number n

Sql> Select Tanh (), tan from dual;

TANH TAN (20)

--------- ---------

1 2.2371609

35.TRUNC

Intercepts a number according to the specified precision

Sql> Select Trunc (124.1666,-2) Trunc1,trunc (124.16666,2) from dual;

TRUNC1 TRUNC (124.16666,2)

--------- ------------------

100 124.16

36.add_months

Add or Subtract month

Sql> Select To_char (add_months (To_date (199912,YYYYMM), 2), yyyymm) from dual;

To_cha

------

200002

Sql> Select To_char (add_months (To_date (199912,yyyymm), -2), yyyymm) from dual;

To_cha

------

199910

37.last_day

Returns the last day of the date

Sql> Select To_char (SYSDATE,YYYY.MM.DD), To_char ((sysdate) +1,yyyy.mm.dd) from dual;

To_char (SY to_char (S

---------- ----------

2004.05.09 2004.05.10

Sql> Select Last_day (sysdate) from dual;

Last_day (S

----------

3 January-May-04

38.months_between (DATE2,DATE1)

Give out the month of date2-date1

Sql> Select Months_between (1 September-December -1999,19-3 month -1999) Mon_between from dual;

Mon_between

-----------

9

Sql>selectmonths_between (To_date (2000.05.20,YYYY.MM.DD), To_date (2005.05.20,YYYY.MM.DD))

MON_BETW from dual;

Mon_betw

---------

-60

39.new_time (Date,this,that)

Gives the date and time of the =other time zone in this time zone

Sql> Select To_char (sysdate,yyyy.mm.dd hh24:mi:ss) Bj_time,to_char (new_time 2 (SYSDATE,PDT,GMT), Yyyy.mm.dd Hh24:mi : ss) Los_angles from dual;

Bj_time Los_angles

------------------- -------------------

2004.05.09 11:05:32 2004.05.09 18:05:32

40.next_day (Date,day)

Give date date and week x to calculate the next one weeks

Sql> Select Next_day (' 1 August-May-2001 ', ' Friday ') next_day from dual;

Next_day

----------

2 May-May-01