现有一属性列记录了时间,datetime格式,如下所示,我想计算各个时间之间的时间差,以秒为单位,求助大侠该怎么做啊?最好能在SQL中做,不用java等其它语言调用。
2005-11-12 21:40:59.730
2005-11-17 13:13:57.640
2006-01-05 11:17:30.030
2006-02-27 20:17:45.077
2006-02-27 20:17:51.233
2006-02-28 18:17:24.450
2006-02-28 18:17:26.733
2006-02-28 18:17:29.560
2006-03-02 21:21:16.903
…………
谢谢ï¼æ²¡éï¼æ¯åè¾¹ä¸è¡ååè¾¹ä¸è¡ï¼æçSQLæ¯2008çã
datetimeè¿ä¸ªå½æ°æä¼ç¨ï¼ä½ç°å¨çé®é¢æ¯æä¹æ ·è½è®©åé¢é£ä¸ªèªå¨å»ååé¢é£ä¸ªï¼è²ä¼¼ç¨åå¨è¿ç¨åä¹ï¼
建表åå½å ¥æ°æ®
create table t (æ¶é´ datetime)è¿è¡å¦ä¸ä»£ç
select a.æ¶é´,datediff(s,a.æ¶é´,b.æ¶é´)ç»ææªå¾