如何将两个varchar值之间的值？ [英] how to two varchar value between value?

问题描述

如何在不同时间之间获取两个varchar值



示例：



Sql server 2008查询

How to get Two varchar values between difference time

Example:

Sql server 2008 query

select cast(dateadd(minute, datediff(minute,ShiftStart , ShiftEnd), 0) as time(0) ) FROM Accounts_DailyAttendance where UserID=2060 AND datename(month,processdate) ='September' and datepart(yyyy,processdate)=2014.

但我想要Sql server 2005，如何在时间间隔内获得Shiftstart（（varchar（50））和Shiftend（（varchar（50））。



示例：

Shiftstart Shiftend

09:00 18:00



我想要结果是在sql server 2005中的09:00:00小时。

But I want Sql server 2005,How to get Shiftstart((varchar(50)) and Shiftend((varchar(50)) time between time.

EXAMPLE:
Shiftstart Shiftend
09:00 18:00

I want Result is 09:00:00 Hours in sql server 2005.

推荐答案

你可以在sql server 2005中使用它

这里是一个例如

you can use this in sql server 2005
here is an eg

create table timediff (time1 varchar(50),time2 varchar(50));

insert into timediff  values('2011-12-09 08:40:00.000','2011-12-09 09:00:00.000');

SELECT convert(varchar,CAST(time2 AS DATETIME)-CAST(time1 AS DATETIME), 8)TIME_DIFF from timediff;

这篇关于如何将两个varchar值之间的值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！