Open cyberhuman opened 1 year ago
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
Some functions don't work because their names match the interval names: DAY(), MONTH(), YEAR(), HOUR(), MINUTE(), SECOND() etc. EXTRACT() doesn't work because it has syntax EXTRACT(<interval_name> FROM <date_expression>) which is not recognized.
DAY()
MONTH()
YEAR()
HOUR()
MINUTE()
SECOND()
EXTRACT()
EXTRACT(<interval_name> FROM <date_expression>)
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
Some functions don't work because their names match the interval names:
DAY(),MONTH(),YEAR(),HOUR(),MINUTE(),SECOND()etc.EXTRACT()doesn't work because it has syntaxEXTRACT(<interval_name> FROM <date_expression>)which is not recognized.