将小时转换为分钟 [英] Convert hours to minutes

问题描述

如何在sql server 2005中将小时(HH:MM)转换为分钟，反之亦然?看一下类似的讨论:

在SQL Server中将分钟转换为小时数 [将小时转换为分钟，SQL Server 2005 [将hh:mm转换为分钟 [ SQL 2005时区转换函数 [ 选择 DATEDIFF(mi，转换(' 转换(' 17:00'))

http://www.sqlservercurry.com/2009/03/convert-number-to-hours-and-minutes-in.html [ 解决方案

Please have a look on similar discussions:

Convert Minutes to Hours in SQL server[^]
Convert hours to minutes, SQL Server 2005[^]
Convert hh:mm into minutes[^]

SQL 2005 Time Zone Conversion Functions[^]

Hi ,
Check this

select DATEDIFF(mi, convert(datetime, '16:00'),  convert(datetime, '17:00'))

http://blog.sqlauthority.com/2009/08/06/sql-server-get-time-in-hourminute-format-from-a-datetime-get-date-part-only-from-datetime/[^]
http://www.sqlservercurry.com/2009/03/convert-number-to-hours-and-minutes-in.html[^]
Best Regards
M.Mitwalli

这篇关于将小时转换为分钟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！