Adding one year to a date : DATE_ADD : Date Time Functions MySQL TUTORIALS

Adding one year to a date

Related Scripts with Example Source Code in same category :
• DATE_ADD(date,INTERVAL expr unit)
• DATE_ADD(curdate(), INTERVAL 1 MICROSECOND);
• DATE_ADD(curdate(), INTERVAL 1 MINUTE);
• DATE_ADD(curdate(), INTERVAL 1 HOUR);
• DATE_ADD(curdate(), INTERVAL 1 DAY);
• DATE_ADD(curdate(), INTERVAL 1 WEEK);
• DATE_ADD(curdate(), INTERVAL 1 MONTH);
• DATE_ADD(curdate(), INTERVAL 1 QUARTER);
• DATE_ADD(curdate(), INTERVAL 1 YEAR);
• DATE_ADD(curdate(), INTERVAL 1.1 SECOND_MICROSECOND)
• DATE_ADD(curdate(), INTERVAL 1 SECOND);
• DATE_ADD(curdate(), INTERVAL 1.1 SECOND);
• DATE_ADD(curdate(), INTERVAL 1.1 MINUTE_MICROSECOND);
• DATE_ADD(curdate(), INTERVAL 1.1 MINUTE_SECOND);
• DATE_ADD(curdate(), INTERVAL 1.1 HOUR_MICROSECOND);
• DATE_ADD(curdate(), INTERVAL 1.1 HOUR_SECOND);
• DATE_ADD(curdate(), INTERVAL '1
• DATE_ADD(curdate(), INTERVAL 1.1 HOUR_MINUTE); (with dot)
• DATE_ADD(curdate(), INTERVAL '1
• DATE_ADD(curdate(), INTERVAL 1.1 DAY_MICROSECOND);
• DATE_ADD(curdate(), INTERVAL '1 1
• DATE_ADD(curdate(), INTERVAL '1 1
• DATE_ADD(curdate(), INTERVAL '1 1' DAY_HOUR);(wihtout
• DATE_ADD(curdate(), INTERVAL 1.1 SECOND_MICROSECOND); (with dot)
• DATE_ADD(curdate(), INTERVAL '1-1' YEAR_MONTH); (with minus sign)
• DATE_ADD(curdate(), INTERVAL '1.1' YEAR_MONTH); (with dot)
• Adding one day to a date
• Adding one month to a date
• Adding one month to start date
• SELECT DATE_ADD('1997-12-31 23
• SELECT DATE_ADD('1997-12-31 23
• SELECT DATE_ADD('1997-12-31 23
• SELECT DATE_SUB('1998-01-01 00
• SELECT DATE_ADD('1998-01-01 00
• SELECT DATE_SUB('1998-01-02', INTERVAL 31 DAY);
• SELECT DATE_ADD('1992-12-31 23
• If you add to or subtract from a date value something that contains a time part, the result is automatically converted to a datetime value.
• SELECT DATE_ADD('1999-01-01', INTERVAL 1 HOUR);
• If the resulting date has a day that is larger than the maximum day for the new month, the day is adjusted to the maximum days in the new month.
• Date arithmetic operations require complete dates
• SELECT '2005-03-32' + INTERVAL 1 MONTH;

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

Vérification Refresh		Enter code
Verification is used to prevent unwanted posts (spam). .