CURDATE, DAYNAME, DATEDIFF, TIME, and etc...
-
Microseconds in MariaDB
In MariaDB 5.3, the TIME, DATETIME, and TIMESTAMP types, along with the tem... -
ADDDATE
Syntax: ADDDATE(date,INTERVAL expr unit), ADDDATE(expr,days)Description: Wh... -
ADDTIME
Syntax: ADDTIME(expr1,expr2) Description: ADDTIME() adds expr2 to expr1 a... -
CONVERT_TZ
Syntax: CONVERT_TZ(dt,from_tz,to_tz) Description: CONVERT_TZ() converts a... -
CURDATE
Syntax: CURDATE() Description: Returns the current date as a value in 'YY... -
CURRENT_DATE
Syntax: CURRENT_DATE, CURRENT_DATE() Description: CURRENT_DATE and CURREN... -
CURRENT_TIME
Syntax: CURRENT_TIME, CURRENT_TIME()Description: CURRENT_TIME and CURRENT_T... -
CURRENT_TIMESTAMP
Syntax: CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()Description: CURRENT_TIMESTAM... -
CURTIME
Syntax: CURTIME()Description: Returns the current time as a value in 'HH:MM... -
DATE FUNCTION
Syntax: DATE(expr) Description: Extracts the date part of the date or dat... -
DATEDIFF
Syntax: DATEDIFF(expr1,expr2)Description: DATEDIFF() returns (expr1 – expr2... -
DATE_ADD
Syntax: DATE_ADD(date,INTERVAL expr unit), DATE_SUB(date,INTERVAL expr unit... -
DATE_FORMAT
Syntax: DATE_FORMAT(date,format) Description: Formats the date value acco... -
DATE_SUB
Syntax: DATE_SUB(date,INTERVAL expr unit)Description: See the description for DATE_ADD(). -
DAY
Syntax: DAY(date)Description: DAY() is a synonym for DAYOFMONTH(). -
DAYNAME
Syntax: DAYNAME(date)Description: Returns the name of the weekday for date.... -
DAYOFMONTH
Syntax: DAYOFMONTH(date)Description: Returns the day of the month for date,... -
DAYOFWEEK
Syntax: DAYOFWEEK(date)Description: Returns the day of the week index for t... -
DAYOFYEAR
Syntax: DAYOFYEAR(date) Description: Returns the day of the year for date... -
EXTRACT
Syntax: EXTRACT(unit FROM date) Description: The EXTRACT() function uses ... -
FROM_DAYS
Syntax: FROM_DAYS(N) Description: Given a day number N, returns a DATE va... -
FROM_UNIXTIME
Syntax: FROM_UNIXTIME(unix_timestamp), FROM_UNIXTIME(unix_timestamp,format)... -
GET_FORMAT
Syntax: GET_FORMAT({DATE|TIME|DATETIME}, {'EUR'|'USA'|'JIS'|'ISO'|'INTERNA... -
HOUR
Syntax: HOUR(time) Description: Returns the hour for time. The range of t... -
LAST_DAY
Syntax: LAST_DAY(date) Description: Takes a date or datetime value and re... -
LOCALTIME
Syntax: LOCALTIME, LOCALTIME()Description: LOCALTIME and LOCALTIME() are sy... -
LOCALTIMESTAMP
Syntax: LOCALTIMESTAMP, LOCALTIMESTAMP()Description: LOCALTIMESTAMP and LOC... -
MAKEDATE
Syntax: MAKEDATE(year,dayofyear) Description: Returns a date, given year ... -
MAKETIME
Syntax: MAKETIME(hour,minute,second) Description: Returns a time value ca... -
MICROSECOND
Syntax: MICROSECOND(expr) Description: Returns the microseconds from the ... -
MINUTE
Syntax: MINUTE(time) Description: Returns the minute for time, in the ran... -
MONTH
Syntax: MONTH(date) Description: Returns the month for date, in the range... -
MONTHNAME
Syntax: MONTHNAME(date) Description: Returns the full name of the month f... -
NOW
Syntax: NOW()Description: Returns the current date and time as a value in '... -
PERIOD_ADD
Syntax: PERIOD_ADD(P,N) Description: Adds N months to period P (in the fo... -
PERIOD_DIFF
Syntax: PERIOD_DIFF(P1,P2) Description: Returns the number of months betw... -
QUARTER
Syntax: QUARTER(date) Description: Returns the quarter of the year for da... -
SECOND
Syntax: SECOND(time) Description: Returns the second for time, in the ran... -
SEC_TO_TIME
Syntax: SEC_TO_TIME(seconds) Description: Returns the seconds argument, c... -
STR_TO_DATE
Syntax: STR_TO_DATE(str,format) Description: This is the inverse of the D... -
SUBDATE
Syntax: SUBDATE(date,INTERVAL expr unit), SUBDATE(expr,days)Description: Wh... -
SUBTIME
Syntax: SUBTIME(expr1,expr2) Description: SUBTIME() returns expr1 - expr2... -
SYSDATE
Syntax: SYSDATE() Description: Returns the current date and time as a val... -
TIME function
Syntax: TIME(expr) Description: Extracts the time part of the time or dat... -
TIMEDIFF
Syntax: TIMEDIFF(expr1,expr2) Description: TIMEDIFF() returns expr1 - exp... -
TIMESTAMP FUNCTION
Syntax: TIMESTAMP(expr), TIMESTAMP(expr1,expr2) Description: With a singl... -
TIMESTAMPADD
Syntax: TIMESTAMPADD(unit,interval,datetime_expr) Description: Adds the i... -
TIMESTAMPDIFF
Syntax: TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2) Description: Re... -
TIME_FORMAT
Syntax: TIME_FORMAT(time,format) Description: This is used like the DATE_... -
TIME_TO_SEC
Syntax: TIME_TO_SEC(time)Description: Returns the time argument, converted ... -
TO_DAYS
Syntax: TO_DAYS(date) Description: Given a date date, returns a day numbe... -
UNIX_TIMESTAMP
Syntax: UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date)Description: If called with n... -
UTC_DATE
Syntax: UTC_DATE, UTC_DATE() Description: Returns the current UTC date as... -
UTC_TIME
Syntax: UTC_TIME, UTC_TIME()Description: Returns the current UTC time as a ... -
UTC_TIMESTAMP
Syntax: UTC_TIMESTAMP, UTC_TIMESTAMP()Description: Returns the current UTC ... -
WEEK
Syntax: WEEK(date[,mode])Description: This function returns the week number... -
WEEKDAY
Syntax: WEEKDAY(date)Description: Returns the weekday index for date (0 = ... -
WEEKOFYEAR
Syntax: WEEKOFYEAR(date)Description: Returns the calendar week of the date ... -
YEAR
Syntax: YEAR(date) Description: Returns the year for date, in the range 1... -
YEARWEEK
Syntax: YEARWEEK(date), YEARWEEK(date,mode)Description: Returns year and we...