求一句关于日期差的查询语句

[sam11]

2007-08-17 15:17:00 跟2007-08-17 15:17:30 差30秒，要怎么写啊

[Limpire]

select datediff(second, '2007-08-17 15:17:00', '2007-08-17 15:17:30')

[chuifengde]

select datediff(second,'2007-08-17 15:17:00','2007-08-17 15:17:30')

[dobear_0922]

select datediff(ss,'2007-08-17 15:17:00','2007-08-17 15:17:30')

[welove1983]

select datediff(second, '2007-08-17 15:17:00', '2007-08-17 15:17:30')

.........
好快啊...LS的

[sam11]

分钟是什么

[Limpire]

参考《联机丛书》
datediff()函数

[Limpire]

year yy, yyyy
quarter qq, q
Month mm, m
dayofyear dy, y
Day dd, d
Week wk, ww
Hour hh
minute mi, n
second ss, s
millisecond ms