Mysqlʱ¼äÏà¼Ó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

MysqlÀïÈçºÎ¼ÆËãʱ¼äÏà¼Ó£¿ÀýÈç10£º23£º22 Óë18£º22£º00µÃ³öʱ¼äÊÇ28£º45£º22¼ÆËãµÄÊÇ×Üʱ¼ä

---

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

ÒýÓÃ

ADDTIME(expr,expr2)
ADDTIME()½« expr2Ìí¼ÓÖÁexpr È»ºó·µ»Ø½á¹û¡£ expr ÊÇÒ»¸öʱ¼ä»òʱ¼äÈÕÆÚ±í´ïʽ£¬¶øexpr2 ÊÇÒ»¸öʱ¼ä±í´ïʽ¡£

mysql> SELECT ADDTIME('1997-12-31 23:59:59.999999',

-> '1 1:1:1.000002');

-> '1998-01-02 01:01:01.000001'

mysql> SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');

-> '03:00:01.999997'

---

ADDTIME(expr1,expr2) 

ADDTIME() adds expr2 to expr1 and returns the result. expr1 is a time or datetime expression, and expr2 is a time expression. 

mysql> SELECT ADDTIME('1997-12-31 23:59:59.999999',
  -> '1 1:1:1.000002');
  -> '1998-01-02 01:01:01.000001'
mysql> SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');
  -> '03:00:01.999997'