Function | Parameters | Result |
---|---|---|
SYSDATE | no parameter | returns current date and time of server |
DATE(s) | s = string of date | returns the date part of the date & time expression |
LAST_DAY(d) | d = date | returns the date of last day of month which has this date d |
NEXT_DAY(d,day) | d = date, day=day of week | returns next day of date d |
GREATEST(d1,d2,…dn) | d1..dn=list of dates | returns latest date from list |
LEAST(d1,d2,…dn) | d1..dn=list of dates | returns oldest date from list |
CURDATE(d) | d=date | returns current date |
CURTIME(d) | d=date | returns current time |
DATE_ADD(d, INTERVAL expr Type_value) | d=date, expr = number of expression, Type_value = See the type_value table below | Adds a specified time interval to a date |
DATE_SUB(d, INTERVAL expr Type_value) | d=date, expr = number of expression, Type_value = See the type_value table below | Substracts a specified time interval to a date |
DAYOFMONTH(d) | d=date | returns day of the month |
DAYOFWEEK(d) | d=date | returns day of week , 1=Sunday, 2=Monday…7=Saturday |
DAYOFYEAR(d) | d=date | returns day of year in the range 1 to 366 |
DAYNAME(d) | d=date | returns name of the weekday for that date |
HOUR(t) | t=time | returns hour field of the specified time in the range 0-23 |
MINUTE(t) | t=time | returns minute field of the specified time in the range 0-59 |
SECOND(t) | t=time | returns second field of the specified time in the range 0-59 |
MONTH(d) | d=date | returns month field of the specified date in the range 0-12 |
QUARTER(d) | d=date | returns quarter of the year for date in the range 0-4 |
MONTHNAME(d) | d=date | returns month name of the specified date in the range 0-12 |
Type_Value |
---|
MICROSECOND |
SECOND |
MINUTE |
HOUR |
DAY |
WEEK |
MONTH |
QUARTER |
YEAR |
SECOND_MICROSECOND |
MINUTE_MICROSECOND |
HOUR_MICROSECOND |
HOUR_SECOND |
HOUR_MINUTE |
DAY_MICROSECOND |
DAY_SECOND |
DAY_MINUTE |
DAY_HOUR |
YEAR_MONTH |
- Examples of Date Function
SELECT SYSDATE FROM DUAL; -> returns current date from server
SELECT HOUR(13:42:10); -> returns 13
SELECT DAYOFWEEK(2016-09-01); -> Returns 1
SELECT DAYOFYEAR(2016-09-01); -> 241
SELECT QUARTER(2016-09-01); -> 3