MySQL-MySQL tutorial

MySQL DATE_ADD application scenario

/* Increase the current time by 1 Ms */
SELECT DATE_ADD (NOW (), INTERVAL 1 MICROSECOND );


/* The current time is reduced by 1 Ms */
SELECT DATE_ADD (NOW (), INTERVAL-1 MICROSECOND );


/* Add 1 second to the current time */
SELECT DATE_ADD (NOW (), INTERVAL 1 SECOND );


/* Current Time minus 1 second */
SELECT DATE_ADD (NOW (), INTERVAL-1 SECOND );


/* Add 1 minute to the current time */
SELECT DATE_ADD (NOW (), INTERVAL 1 MINUTE );


/* The current time minus 1 minute */
SELECT DATE_ADD (NOW (), INTERVAL-1 MINUTE );


/* Add the current time to 1 hour */
SELECT DATE_ADD (NOW (), INTERVAL 1 HOUR );


/* Current Time minus 1 hour */
SELECT DATE_ADD (NOW (), INTERVAL-1 HOUR );


/* Add the current date to 1 day */
SELECT DATE_ADD (NOW (), INTERVAL 1 DAY );


/* The current date minus one day */
SELECT DATE_ADD (NOW (), INTERVAL-1 DAY );


/* Add the current date to July 15, January */
SELECT DATE_ADD (NOW (), INTERVAL 1 MONTH );


/* The current date minus January */
SELECT DATE_ADD (NOW (), INTERVAL-1 MONTH );


/* Add the current date to the first quarter */
SELECT DATE_ADD (NOW (), INTERVAL 1 QUARTER );


/* The current date minus one quarter */
SELECT DATE_ADD (NOW (), INTERVAL-1 QUARTER );


/* Add the current date to 1 year */
SELECT DATE_ADD (NOW (), INTERVAL 1 YEAR );


/* The current date minus one year */
SELECT DATE_ADD (NOW (), INTERVAL-1 YEAR );