Date functions

FunctionDescription
ADD_MONTHS(d, n)Date d plus n months
LAST_DAY(d)Last day of the month containing date d
MONTHS_BETWEEN(d, e)Months between dates d and e
NEXT_DAY(d, weekday)The first weekday (mon, tue, etc.) after d
NEW_TIME(d, z1, z2)Convert date/time d from time zone z1 to z2
ROUND(d[, fmt])d rounded on fmt (the default for fmt is midnight)
TRUNC(d[, fmt])d truncated on fmt (the default for fmt is midnight)
EXTRACT(c FROM d)Extract date/time component c from expression d
SysdateReturns the current operating system date from database server
Home »
Oracle » 
Date_Functions