时间差问题

[wynlc]

select datediff(hh,'2014-02-08 17:00','2014-02-08 18:10')
1
select datediff(n,'2014-02-08 17:00','2014-02-08 18:10')
70

想得到两时间做差只要大于一小时就作为两小时
例如:'2014-02-08 17:00' 与 '2014-02-08 18:10'做差得出2个小时

[无涯大者]

case when 判断下

select case when(cast(datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') as int))>1 then 2 else datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') end

供参考!

[wynlc]

引用 1 楼 fengqingtao2008 的回复:

case when 判断下

select case when(cast(datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') as int))>1 then 2 else datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') end

供参考!

不是只是一个小时情况 例如:'2014-02-08 17:00' 与 '2014-02-08 19:05'做差得出3个小时

[昵称90天可改一次]

select case when datediff(n,'2014-02-08 17:00','2014-02-08 18:10')%60>1
		then datediff(hh,'2014-02-08 17:00','2014-02-08 18:10')+1
		else datediff(hh,'2014-02-08 17:00','2014-02-08 18:10')
		end

[昵称90天可改一次]

查分钟 除以60 有余数则小时+1 没有则正常显示

[昵称90天可改一次]

应该大于0

select case when datediff(n,'2014-02-08 17:00','2014-02-08 18:10')%60>0
        then datediff(hh,'2014-02-08 17:00','2014-02-08 18:10')+1
        else datediff(hh,'2014-02-08 17:00','2014-02-08 18:10')
        end

[LongRui888]

引用 2 楼 wynlc 的回复:

[quote=引用 1 楼 fengqingtao2008 的回复:] case when 判断下

select case when(cast(datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') as int))>1 then 2 else datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') end

供参考!

不是只是一个小时情况 例如:'2014-02-08 17:00' 与 '2014-02-08 19:05'做差得出3个小时[/quote] 计算分钟差，然后除以60，然后求最大整数：

select ceiling(datediff(minute,'2014-02-08 17:00','2014-02-08 19:05')/60.0)
/*
3
*/

[LongRui888]

select ceiling(datediff(minute,'2014-02-08 17:00','2014-02-08 18:10')/60.0)
/*
2
*/

[wynlc]

引用 6 楼 yupeigu 的回复:

[quote=引用 2 楼 wynlc 的回复:] [quote=引用 1 楼 fengqingtao2008 的回复:] case when 判断下

select case when(cast(datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') as int))>1 then 2 else datediff(hh,'2014-02-08 17:00','2014-02-08 18:10') end

供参考!

不是只是一个小时情况 例如:'2014-02-08 17:00' 与 '2014-02-08 19:05'做差得出3个小时[/quote] 计算分钟差，然后除以60，然后求最大整数：

select ceiling(datediff(minute,'2014-02-08 17:00','2014-02-08 19:05')/60.0)
/*
3
*/

[/quote]