MySQL Date Functions

 How to work Date Functions in MySql:

Code:

CREATE TABLE personal(

id INT NOT NULL,

name VARCHAR(50) NOT NULL,

    percentage INT NOT NULL,

age INT NOT NULL,

gender VARCHAR(1) NOT NULL,

city INT NOT NULL,

    courses INT NOT NULL,

    PRIMARY KEY (id),

FOREIGN KEY (city) REFERENCES City (cid),

    FOREIGN KEY (courses) REFERENCES Courses (course_id)  

);

INSERT INTO personal(id,name,percentage,age,gender,city,courses)

VALUES

(1,"Aqib","45","13","M",1,1),

(2,"Khadija","56","21","F",2,2),

(3,"Salman Khan","62","20","M",1,1),

(4,"Aqeela","47","18","F",3,1),

(5,"Saqib","74","22","M",1,3),

(6,"Abraham","64","21","M",2,2),

(7,"Shahid","52","20","M",1,3);

Examples:

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;