• ⌂ Date & Time
• Functions
  • ADDDATE()
  • ADDTIME()
  • CURDATE()
  • CURRENT_DATE()
  • CURRENT_TIME()
  • CURRENT_TIMESTAMP()
  • CURTIME()
  • DATE()
  • DATEDIFF()
  • DATE_ADD()
  • DATE_FORMAT()
  • DATE_SUB()
  • DAY()
  • DAYOFMONTH()
  • DAYOFYEAR()
  • HOUR()
  • MICROSECOND()
  • MINUTE()
  • MONTH()
  • NOW()
  • SECOND()
  • TIME()
  • TIMEDIFF()
  • UNIX_TIMESTAMP()
  • WEEK()
  • WEEKDAY()
  • YEAR()

Date & Time Query Functions

Date and time query functions are used to analyze and manipulate dates, times and timestamps.  Many of these functions take date, time and timestamp parameters, so their function prototypes may reference the following types.

• date - refers to a date-only value, typically in YYYY-MM-DD format.
• time - refers to a time-only value, typically in HH:MM:SS format.
• timestamp - refers to a date time, date or time value, typically in "YYYY-MM-DD HH:MM:SS", "YYYY-MM-DD" or "HH:MM:SS" format, but in some cases something like "DD HH:MM:SS" format is also allowed.  See function details for exact supported options.
• mixed - when more than one type is allowed, the parameter definition should explain what the options are.

Microseconds are also generally supported by adding a decimal and number of microseconds after seconds.  However, the repository will not store microsecond values yet, so that information will be lost if a timestamp with microseconds is approved, saved or stored to the repository.

• < SUM()
• ADDDATE() >