MySQL date and time addition and subtraction sample code

I was reviewing MySQL recently and happened to see MySQL date and time. I will leave a note for myself and share it with you.

• now (); Current specific date and time
• curdate(); Current date
• curtime(); Current time

1.MySQL adds or subtracts a time interval

Set the current date variable

set @dt = now(); //Set the current date select @dt; //Query variable value 

Adding and subtracting a time interval functions date_add() and date_sub()

date_add('a certain date and time', interval 1 time type name);

Example:

select date_add(@dt, interval 1 year); //add 1 yearselect date_add(@dt, interval 1 month); //add 1 month

quarter: quarter, week: week, day: day, hour: hour, minuter: minute, second: second, microsecond: millisecond

Note: You can also add or subtract a time directly without using variables, such as: select date_add('1998-01-01', interval 1 day);

2. Subtract dates

datediff(date1,date2): Subtract two dates, date1 minus date2 to get the number of days after the subtraction

timediff(time1, time2): Subtract time1 from time2 and return the difference.

select timediff('2019-06-03 12:30:00', '2019-06-03 12:29:30');

Equivalent to

select timediff('12:30:00', '12:29:30');

This is the end of this article about sample code for MySQL date and time addition and subtraction. For more information about MySQL date and time addition and subtraction, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!