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 ADDDATE("2019-06-15",INTERVAL 10 DAY) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 50 DAY) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 1 MONTH) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 1 WEEK) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 1 YEAR) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 1 QUARTER) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 12 HOUR) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 24 HOUR) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 500 MINUTE) AS Date;

SELECT ADDDATE("2019-06-15",INTERVAL 5000 MINUTE) AS Date;

SELECT DATE_ADD("2019-06-15",INTERVAL 5000 MINUTE) AS Date;

SELECT MAKEDATE(2019,3);

SELECT MAKEDATE(2016,3);

SELECT SUBDATE("2019-06-15",INTERVAL 1 DAY) AS Date;

SELECT SUBDATE("2019-06-15",INTERVAL 10 DAY) AS Date;

SELECT SUBDATE("2019-06-15",INTERVAL 10 MONTH) AS Date;

SELECT DATEDIFF("2019-06-15","2019-02-10") AS Date;

SELECT DATEDIFF("2019-06-15","2019-06-01") AS Date;

SELECT DATEDIFF("2019-06-15","2018-06-01") AS Date;

SELECT TO_DAYS("2019-06-15") AS Date;

SELECT FROM_DAYS("685000") AS Date;

SELECT PERIOD_ADD("685000",5) AS Date;

SELECT PERIOD_DIFF("685000","695000") AS Date;

SELECT DATE_FORMAT("2019-06-15","%Y") AS Date;

SELECT DATE_FORMAT("2019-06-15","%d/%b/%Y") AS Date;

SELECT DATE_FORMAT("2019-06-15","%d-%c-%Y") AS Date;

SELECT DATE_FORMAT("2019-06-15","%d/%b/%y") AS Date;

SELECT DATE_FORMAT("2019-06-15","%d-%c-%y, %W") AS Date;

SELECT DATE_FORMAT("2019-06-15 02:30:50:20","%d-%c-%y, %h:%i") AS Date;

SELECT STR_TO_DATE("July 10 2019","%M %d %Y") AS Date;