Oracle 5.0, Reference Manual

Page: 936 / 3232

Date and Time Functions
916
Name Description
GET_FORMAT()
[924] Return a date format string
HOUR()
[924] Extract the hour
LAST_DAY
[925] Return the last day of the month for the argument
LOCALTIME()
,
LOCALTIME
[925] Synonym for NOW()
LOCALTIMESTAMP
,
LOCALTIMESTAMP()
[925]
Synonym for NOW()
MAKEDATE()
[925] Create a date from the year and day of year
MAKETIME
[925] MAKETIME()
MICROSECOND()
[925] Return the microseconds from argument
MINUTE()
[925] Return the minute from the argument
MONTH()
[925] Return the month from the date passed
MONTHNAME()
[926] Return the name of the month
NOW()
[926] Return the current date and time
PERIOD_ADD()
[926] Add a period to a year-month
PERIOD_DIFF()
[926] Return the number of months between periods
QUARTER()
[927] Return the quarter from a date argument
SEC_TO_TIME()
[927] Converts seconds to 'HH:MM:SS' format
SECOND()
[927] Return the second (0-59)
STR_TO_DATE()
[927] Convert a string to a date
SUBDATE()
[928] A synonym for DATE_SUB() when invoked with three
arguments
SUBTIME()
[928] Subtract times
SYSDATE()
[928] Return the time at which the function executes
TIME_FORMAT()
[930] Format as time
TIME_TO_SEC()
[930] Return the argument converted to seconds
TIME()
[929] Extract the time portion of the expression passed
TIMEDIFF()
[929] Subtract time
TIMESTAMP()
[929] With a single argument, this function returns the date or
datetime expression; with two arguments, the sum of the
arguments
TIMESTAMPADD()
[929] Add an interval to a datetime expression
TIMESTAMPDIFF()
[930] Subtract an interval from a datetime expression
TO_DAYS()
[930] Return the date argument converted to days
UNIX_TIMESTAMP()
[931] Return a UNIX timestamp
UTC_DATE()
[932] Return the current UTC date
UTC_TIME()
[932] Return the current UTC time
UTC_TIMESTAMP()
[932] Return the current UTC date and time
WEEK()
[932] Return the week number
WEEKDAY()
[933] Return the weekday index
WEEKOFYEAR()
[933] Return the calendar week of the date (0-53)
YEAR()
[933] Return the year
YEARWEEK()
[934] Return the year and week