/* 034- Date Functions */ SELECT CURRENT_DATE(); SELECT CURDATE(); SELECT SYSDATE(); SELECT NOW(); SELECT DATE("2019-10-15 09:34:21") AS DATE; SELECT MONTH("2019-10-15 09:34:21") AS DATE; SELECT MONTHNAME("2019-10-15 09:34:21") AS DATE; SELECT YEAR("2019-10-15 09:34:21") AS DATE; SELECT QUARTER("2019-10-15 09:34:21") AS DATE; SELECT QUARTER("2019-03-15 09:34:21") AS DATE; SELECT DAY("2019-10-15 09:34:21") AS DATE; SELECT DAYOFMONTH("2019-10-15 09:34:21") AS DATE; SELECT DAYNAME("2019-06-15 09:34:21") AS DATE; SELECT DAYOFWEEK("2019-03-15 09:34:21") AS DATE; SELECT DAYOFYEAR("2019-06-15 09:34:21") AS DATE; SELECT WEEK("2019-06-15 09:34:21") AS DATE; SELECT WEEKDAY("2019-03-15 09:34:21") AS DATE; SELECT YEARWEEK("2019-06-15 09:34:21") AS DATE; SELECT LAST_DAY("2019-02-15 09:34:21") AS DATE; SELECT EXTRACT(MONTH FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(DAY FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(YEAR FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(WEEK FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(HOUR FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(MINUTE FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(SECOND FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(MICROSECOND FROM "2019-03-15 09:34:21") AS DATE; SELECT EXTRACT(HOUR_MINUTE FROM "2019-03-15 09:34:21") AS DATE;