SQL查询中的日期时间列问题 [英] Problem for datetime columns in sql query

问题描述

m使用sql server 2005
在我的数据库中，日期时间Indate和outdate中有两列

我想弄清楚时间之间的差异.
例如:

m using sql server 2005
In my database I have two columns in datetime Indate and outdate

I want get the difference between the time.
for ex:

Indate                   Outdate
11/19/2012 12:00:00 AM   11/19/2012 1:30:00 AM

我想从中得到的差是1.5，该怎么办呢?请帮助我

I want to get the difference is 1.5 from that how to do it? pls help me

推荐答案

尝试:

SELECT CAST(DATEDIFF(minute,'11/19/2012 12:00:00 AM','11/19/2012 1:30:00 AM') AS FLOAT) / 60 AS DiffDate

请参见以下示例

see this example

select datediff(mi,'2012-11-19 12:00:00 AM','2012-11-19 1:30:00 AM')/60 as hour,
       datediff(mi,'2012-11-19 12:00:00 AM','2012-11-19 1:30:00 AM')%60 as min

--output
--hour  min
------------
--1     30

注意:格式"列的格式应为日期时间

祝您编码愉快！
:)

Note: Format column''s format should be datetime

Happy Coding!
:)

这篇关于SQL查询中的日期时间列问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！