SELECT TIMESTAMPADD(FRAC_SECOND,1,'2003-01-02'); : TIMESTAMPADD « Date Time Functions « MySQL Tutorial





mysql>
mysql>
mysql> SELECT TIMESTAMPADD(FRAC_SECOND,1,'2003-01-02');
+------------------------------------------+
| TIMESTAMPADD(FRAC_SECOND,1,'2003-01-02') |
+------------------------------------------+
| 2003-01-02 00:00:00.000001               |
+------------------------------------------+
1 row in set (0.00 sec)










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');