MySQL中TIMESTAMPDIFF跟TIMESTAMPADD函数的用法(转)

MySQL中TIMESTAMPDIFF和TIMESTAMPADD函数的用法(转)

1. mysql>?select?TIMESTAMPADD(MINUTE,8820,'2012-08-24?09:00:00');??+-------------------------------------------------+???
2. |?TIMESTAMPADD(MINUTE,8820,'2012-08-24?09:00:00')?|??+-------------------------------------------------+???
3. |?2012-08-30?12:00:00?????????????????????????????|???+-------------------------------------------------+???
4. 1?row?in?set?(0.00?sec) ?