TIMESTAMPADD « Date Time Functions « MySQL Tutorial





14.46.TIMESTAMPADD
14.46.1.TIMESTAMPADD(unit,interval,datetime_expr) adds the integer expression interval to datetime_expr
14.46.2.SELECT TIMESTAMPADD(SECOND,1,'2003-01-02');
14.46.3.SELECT TIMESTAMPADD(FRAC_SECOND,1,'2003-01-02');
14.46.4.SELECT TIMESTAMPADD(HOUR,1,'2003-01-02');
14.46.5.SELECT TIMESTAMPADD(DAY,1,'2003-01-02');
14.46.6.SELECT TIMESTAMPADD(WEEK,1,'2003-01-02');
14.46.7.SELECT TIMESTAMPADD(MONTH,1,'2003-01-02');
14.46.8.SELECT TIMESTAMPADD(QUARTER,1,'2003-01-02');
14.46.9.SELECT TIMESTAMPADD(YEAR,1,'2003-01-02');