如何在sqlsever下返回两个日期的相差分钟数？(100分)

嘻

嘻嘻哈

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-05

• #1

 

S

Shd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-05

• #2

二者之差*24*60
这是从一天是24小时算出来的。

SQL7。0里的datatime类型最小单位是千分之三秒。

 

M

mataijin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-05

• #3

SELECT DATEDIFF(mi,'2000-12-30', '2001-12-31')

 

S

sportsman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-05

• #4

mataijin is right:
SELECT DATEDIFF(minute,'2000-12-30', '2001-12-31')

 

嘻

嘻嘻哈

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-03-06

• #5