有关DATEDIFF用法(急)

Question

select right(10000+DATEDIFF(mi,'2004-01-08 00:09:36','2004-01-08 00:13:19'),4)结果:
-------- 
0004（所影响的行数为 1 行）

Answer 1

select right(0000+DATEDIFF(mi,'2004-01-08 00:09:36','2004-01-08 00:13:19'),4)
多了一个1

Answer 2

select right('0000'+cast(DATEDIFF(mi,'2004-01-08 00:09:36','2004-01-08 00:13:19') as varchar(1000)),4)

Answer 3

select right('0000'+cast(DATEDIFF(mi,'2004-01-08 00:09:36','2004-01-08 00:13:19') as varchar(4)),4)

Answer 4

不好意思搞错了。
select right(‘0000’+DATEDIFF(mi,'2004-01-08 00:09:36','2004-01-08 00:13:19'),4)
邹的方法更好。