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

Date & Time Query Functions

The following date & time functions are supported by cQL.

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.

• < User
• ADDDATE() >