日期问题，在线等。。。。

Question

在MySQL中得到两个日期时间的差值
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=4531

Answer 1

select date_add('2003-05-05 12:00:00',INTERVAL -2 hour),date_add('2003-05-05 12:00:00',INTERVAL 2 hour);
===========================================================
date_add('2003-05-05 12:00:00',INTERVAL -2 hour)    date_add('2003-05-05 12:00:00',INTERVAL 2 hour)
2003-05-05 10:00:00                                  2003-05-05 14:00:00
===========================================================http://www.fanqiang.com/a2/b1/20010705/150000802.html

Answer 2

应该结帖了吧。select * from 表名 where unix_timestamp(current_timestamp)-unix_timestamp(aaa01)<7200;

Answer 3

query1.close;
Select * From Table Where  aaa01=:Date1 
Datetime1.Datetime = Datetime1.Datetime+(Datetime1.time-2);
Params[0].AsString :=  FormatDateTime('yyyy-mm-dd 00:00:00',datetime1.DateTime);
Query1.open;