Oracle 5.0, Reference Manual

Page: 886 / 3232

Function and Operator Reference
866
Name Description
CURRENT_TIMESTAMP()
,
CURRENT_TIMESTAMP
[918]
Synonyms for NOW()
CURRENT_USER()
,
CURRENT_USER
[959]
The authenticated user name and host name
CURTIME()
[918] Return the current time
DATABASE()
[960] Return the default (current) database name
DATE_ADD()
[919] Add time values (intervals) to a date value
DATE_FORMAT()
[921] Format date as specified
DATE_SUB()
[922] Subtract a time value (interval) from a date
DATE()
[918] Extract the date part of a date or datetime expression
DATEDIFF()
[919] Subtract two dates
DAY()
[922] Synonym for DAYOFMONTH()
DAYNAME()
[923] Return the name of the weekday
DAYOFMONTH()
[923] Return the day of the month (0-31)
DAYOFWEEK()
[923] Return the weekday index of the argument
DAYOFYEAR()
[923] Return the day of the year (1-366)
DECODE()
[954] Decodes a string encrypted using ENCODE()
DEFAULT()
[965] Return the default value for a table column
DEGREES()
[909] Convert radians to degrees
DES_DECRYPT()
[954] Decrypt a string
DES_ENCRYPT()
[954] Encrypt a string
DIV
[907] Integer division
/
[906] Division operator
ELT()
[888] Return string at index number
ENCODE()
[955] Encode a string
ENCRYPT()
[955] Encrypt a string
<=>
[876] NULL-safe equal to operator
=
[875] Equal operator
EXP()
[910] Raise to the power of
EXPORT_SET()
[888] Return a string such that for every bit set in the value bits,
you get an on string and for every unset bit, you get an off
string
EXTRACT()
[923] Extract part of a date
FIELD()
[888] Return the index (position) of the first argument in the
subsequent arguments
FIND_IN_SET()
[888] Return the index position of the first argument within the
second argument
FLOOR()
[910] Return the largest integer value not greater than the
argument
FORMAT()
[889] Return a number formatted to specified number of decimal
places
FOUND_ROWS()
[960] For a SELECT with a LIMIT clause, the number of rows that
would be returned were there no LIMIT clause