在sql Server中使用持续时间的计划的开始和结束时间 [英] start and end time of a schedule using duration in sql Server
本文介绍了在sql Server中使用持续时间的计划的开始和结束时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
声明 @ Table1 表
(TimeSchedule 时间,
持续时间时间,
EnteredOn datetimeoffset)
插入 @ Table1 值(CAST(0x00907E0000000000 AS 时间),CAST(0x0008070000000000) AS 时间),' 2015-11-24')
插入 @ Table1 值(CAST(0x00A08C0000000000 AS 时间),CAST(0x0008070000000000 AS 时间),' 2015-11-24')
SELECT CONCAT( CONVERT ( DATE ,EnteredOn),' ',TimeSchedule,' to',( CONVERT ( VARCHAR ( 8 ), CONVERT ( DATETIME ,TimeSchedule)+ CONVERT ( DATETIME ,持续时间), 108 ))) AS 日间 FROM @ Table1
输出:
2015-11-24 09:00:00到09:30:00
2015-11-24 10:00:00到10:30:00
我想要我的输出如2015-11-24 09:00:00至10:30:00 Plz帮我找到了ts。
解决方案
你好,
请在下面查询一下
声明 @ Table1 表
(TimeSchedule 时间,
持续时间时间,
EnteredOn datetimeoffset)
插入 @ Table1 值(CAST(0x00907E0000000000 AS 时间),CAST(0x0008070000000000 AS 时间),< span class =code-string>' 2015-11-24')
插入 @ Table1 values (CAST(0x00A08C0000000000 AS 时间),CAST(0x0008070000000000 AS 时间),' 2015-11-24')
SELECT CONCAT( CONVERT ( DATE ,EnteredOn),' ',TimeSchedule,' to',( CONVERT ( VARCHAR ( 8 ),dateadd(hh,CAST( CONVERT ( DATETIME ,TimeSchedule) AS bigint ),' 1/1/197 0 10:00:00')+ CONVERT ( DATETIME ,持续时间), 108 ))) AS 日间 FROM @表1 跨度>
declare @Table1 TABLE
( TimeSchedule time ,
Duration time ,
EnteredOn datetimeoffset )
Insert @Table1 values ( CAST(0x00907E0000000000 AS Time), CAST(0x0008070000000000 AS Time),'2015-11-24')
Insert @Table1 values ( CAST(0x00A08C0000000000 AS Time), CAST(0x0008070000000000 AS Time),'2015-11-24')
SELECT CONCAT(CONVERT(DATE,EnteredOn), ' ' , TimeSchedule,' to ', (CONVERT(VARCHAR(8),CONVERT(DATETIME,TimeSchedule)+ CONVERT(DATETIME,Duration),108)) ) AS Daytime FROM @Table1
OUTPUT:
2015-11-24 09:00:00 to 09:30:00
2015-11-24 10:00:00 to 10:30:00
I want my output as 2015-11-24 09:00:00 to 10:30:00. Plz help me to find ts.
解决方案
Hi,
Please try below query
declare @Table1 TABLE ( TimeSchedule time , Duration time , EnteredOn datetimeoffset ) Insert @Table1 values ( CAST(0x00907E0000000000 AS Time), CAST(0x0008070000000000 AS Time),'2015-11-24') Insert @Table1 values ( CAST(0x00A08C0000000000 AS Time), CAST(0x0008070000000000 AS Time),'2015-11-24') SELECT CONCAT(CONVERT(DATE,EnteredOn), ' ' , TimeSchedule,' to ', (CONVERT(VARCHAR(8),dateadd(hh,CAST(CONVERT(DATETIME,TimeSchedule ) AS bigint),'1/1/1970 10:00:00') + CONVERT(DATETIME,Duration),108)) ) AS Daytime FROM @Table1
这篇关于在sql Server中使用持续时间的计划的开始和结束时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文