如何在sql server中及时获取minuts [英] How to Get Minuts in time fomat in sql server
本文介绍了如何在sql server中及时获取minuts的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何仅在04:30:00获得分钟
在我的源代码下面
例如:
选择转换(varchar,CAST('13:30:00'AS DATETIME)-CAST('09:00'AS DATETIME),8)
以上查询运行结果是04:30:00我不想要这个结果。
我想要(小时* 60 +分钟)结果是270分钟
谢谢
How to get minutes only in 04:30:00
Below my source code
Ex:
select convert(varchar,CAST('13:30:00' AS DATETIME)-CAST('09:00' AS DATETIME), 8)
above query run came result is 04:30:00 idon't want this result.
I want (Hours * 60 + minutes) Result is 270 Minutes
Thanks
推荐答案
试试这个
Try this
DECLARE @Dt AS DATETIME
SELECT @Dt= CAST('13:30:00' AS DATETIME)-CAST('09:00' AS DATETIME)
SELECT CAST(((DATEPART(HOUR,@Dt)*60)+DATEPART(MINUTE,@Dt)) AS VARCHAR)+' Minutes'
Result:
<pre lang="text">270 Minutes
更新:
最好使用以下
Update:
It's better to use following
DECLARE @Dt DATETIME
SET @Dt = '01-01-2001 07:10:20'SELECT @Dt= CAST('13:30:00' AS DATETIME)-CAST('09:00' AS DATETIME)
SELECT CAST(DATEDIFF(MINUTE, DATEADD(DAY, DATEDIFF(DAY, 0, @Dt), 0), @Dt) AS VARCHAR)+' Minutes'
希望,它会有所帮助:)
Hope, it helps :)
阅读以下内容: http://stackoverflow.com/questions/4536330/datetime-to-totalminute-in-sql [ ^ ]
Read the following: http://stackoverflow.com/questions/4536330/datetime-to-totalminute-in-sql[^]
试试这个:
SELECT CONVERT(VARCHAR,DATEDIFF(MINUTE,CAST('09:00'AS DATETIME),CAST('13:30:00'AS DATETIME)))
Try this:
SELECT CONVERT(VARCHAR, DATEDIFF(MINUTE, CAST('09:00' AS DATETIME), CAST('13:30:00' AS DATETIME)))
这篇关于如何在sql server中及时获取minuts的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文