ADDDATE -- Adds a date interval (eg: 10 DAY) to a date (eg: 20/01/20) and returns the result (eg: 20/01/30). ADDTIME -- Adds a time interval (eg: 02:00) to a time or datetime (05:00) and returns the result (07:00). CURDATE -- Gets the current date. CURRENT_DATE -- Same as CURDATE. CURRENT_TIME -- Gest the current time. CURRENT_TIMESTAMP -- Gets the current date and time. CURTIME -- Same as CURRENT_TIME. DATE -- Extracts the date from a datetime expression. DATEDIFF -- Returns the number of days between the 2 given dates. DATE_ADD -- Same as ADDDATE. DATE_FORMAT -- Formats the date to the given pattern. DATE_SUB -- Subtracts a date interval (eg: 10 DAY) to a date (eg: 20/01/20) and returns the result (eg: 20/01/10). DAY -- Returns the day for the given date. DAYNAME -- Returns the weekday name for the given date. DAYOFWEEK -- Returns the index for the weekday for the given date. DAYOFYEAR -- Returns the day of the year for the given date. EXTRACT -- Extracts from the date the given part (eg MONTH for 20/01/20 = 01). FROM DAYS -- Returns the date from the given numeric date value. HOUR -- Returns the hour from the given date. LAST DAY -- Gets the last day of the month for the given date. LOCALTIME -- Gets the current local date and time. LOCALTIMESTAMP -- Same as LOCALTIME. MAKEDATE -- Creates a date and returns it, based on the given year and number of days values. MAKETIME -- Creates a time and returns it, based on the given hour, minute and second values. MICROSECOND -- Returns the microsecond of a given time or datetime. MINUTE -- Returns the minute of the given time or datetime. MONTH -- Returns the month of the given date. MONTHNAME -- Returns the name of the month of the given date. NOW -- Same as LOCALTIME. PERIOD_ADD -- Adds the given number of months to the given period. PERIOD_DIFF -- Returns the difference between 2 given periods. QUARTER -- Returns the year quarter for the given date. SECOND -- Returns the second of a given time or datetime. SEC_TO_TIME -- Returns a time based on the given seconds. STR_TO_DATE -- Creates a date and returns it based on the given string and format. SUBDATE -- Same as DATE_SUB. SUBTIME -- Subtracts a time interval (eg: 02:00) to a time or datetime (05:00) and returns the result (03:00). SYSDATE -- Same as LOCALTIME. TIME -- Returns the time from a given time or datetime. TIME_FORMAT -- Returns the given time in the given format. TIME_TO_SEC -- Converts and returns a time into seconds. TIMEDIFF -- Returns the difference between 2 given time/datetime expressions. TIMESTAMP -- Returns the datetime value of the given date or datetime. TO_DAYS -- Returns the total number of days that have passed from ‘00-00-0000’ to the given date. WEEK -- Returns the week number for the given date. WEEKDAY -- Returns the weekday number for the given date. WEEKOFYEAR -- Returns the week number for the given date. YEAR -- Returns the year from the given date. YEARWEEK -- Returns the year and week number for the given date.
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter