Units Digital Function Units Digital Digital Data, Perform Mathematics and Arithmetic Operations. All functions have numeric parameters and returns a digital value. All the operands and values of all triangle functions are radians rather than angles, and Oracle does not provide built-in radians and angles of conversion functions.
ABS (
)
Returns the absolute value of N
ACOS
)
The anti-mystery function returns to the number of -1 to 1. n represents an arc
SELECT ACOS (-1) Pi, ACOS (1) Zero from DualPi ZERO3.14159265 0
ASIN (
)
Any normal mystery function, returning -1 to 1, n represents the radia
ATAN
)
Anytute cleaning function, returning N of the anterior correction value, n represents the radians.
CEIL
)
Returns the minimum integer greater than or equal to N.
COS
)
Returns the Yu Xuan value of N, n is an arc
Cosh
)
Returns the hypotonics of n, n is a number.
SELECT COSH (<1.4>) from Dualcosh (1.4) 2.15089847
Exp
)
Returns the n power of E, E = 2.71828183.
Floor
)
Returns the maximum integer that is less than or equal to N.
LN (
)
Returns Natural logarithm of N, n must be greater than 0
Log
,
)
Returns the logarithm of N1
MOD
)
Returns N1 divided by the remainder of N2,
Power
,
)
Returns N2 of N1
Round
,
)
Returns the value of N1 of the N2-bit N2 bit of the decimal point, the default value of N2 is 0, which is the most close to the decimal point. If the N2 is rounded to the corresponding position on the left side of the decimal point, N2 must be an integer.
Select Round (12345, -2), Round (12345.54321, 2) from Dualround (12345, -2) Round (12345.54321, 2) 12300 12345.54
SIGN
)
If n is a negative number, return -1, if n is a positive number, returns 1, if n = 0 returns 0.
Sin
)
Returns the nirange value of N, n is an arc.
Sinh
)
Returns the hyperbolic nature value of n, n is the curvature.
SQRT
)
Returns the square root of N, n is an arc
Tan
)
Returns the positive cut value of N, n is an arc
Tanh (
)
Returns the hyperbolic value of N, n is an arc
Trunc
,
)
Returns the value of N1 of the N2-bit decimal, the N2 default setting is 0, when N2 is an integer, the N1 cut is an integer, if the N2 is negative, and the corresponding position on the left side of the decimal point is on the left side of the decimal point. .
Single line date function
The single-line date function operation DATA data type, most of which have the parameters of the DATA data type, and most of the returns are also the value of the DATA data type.
Add_MONTHS (
)
Returns the date D plus the result of the month. i can make any integer. If i is a decimal, then the database will be implicitly converted into an integer, which will cut the part behind the decimal point.
Last_day (
)
Function returns the last day of the month containing the date D
MONTHS_BETWEEN
,
)
Returns the number of months between D1 and D2, if the date of D1 and D2 is the same, or the last day of the month, then an integer will be returned, otherwise the result will contain a score.
NEW_TIME
,
,
)
D1 is a date data type. When the date and time in the time zone TZ1 is D, the date and time in the time zone TZ2 is returned. TZ1 and TZ2 strings.
NEXT_DAY
,
)
On the first day of the condition given by DOW after the date D, DOW specifies one day in the previous session, and the returned time component is the same as the time component of D.
Select next_day ('01-Jan-2000 ',' Monday ') "1st Monday", Next_DAY ('01-Nov-2004', 'Tuesday') 7 "2nd Tuesday") from Dual; 1st Monday 2nd Tuesday03-Jan -2000 09-NOV-2004Round (
[,
])
Return the date D to the format specified by the FMT, FMT is a string.
Syadate
The function does not have a parameter, returns the current date and time.
Trunc
[,
])
Returns the date d of the unit specified by the FMT.
