计算日期时间之间的差异 [英] Calculating difference between datetime

问题描述

嗨
我在计算2之间的差异时遇到问题
max(startdate)和min(enddate)使用sqlserver 2008中的存储过程.startdate和enddate的数据类型为varchar(50)

  SELECT 
 转换(日期时间，min(startDate))- convert ( datetime ，max(endDate))
来自项目

如何执行此计算

解决方案

使用DateDiff

 选择 DATEDIFF(DAY，转换(日期]))，日期时间，最大值([日期]))))) AS  NumberOfDays 来自表名

要获取绝对(正)值，请使用ABS [ ^ ]函数:

  SELECT  ABS(DATEDIFF(DAY，MIN([startdate])，MAX([enddate]))表名
 
 
Hi


I am having a problem as i am trying to calculate the defference between 2 

max(startdate) and min(enddate) using a stored procedure in sqlserver 2008. my datatype for startdate and enddate is varchar(50)



SELECT  
 convert(datetime,min(startDate)) - convert(datetime,max(endDate))
from projects


How can i perform this calculation
解决方案
Use DateDiff

SELECT DATEDIFF(DAY, Convert(datetime,MIN([date])),CONVERT(datetime,MAX([date]))) AS NumberOfDays from tablename

To get absolute (positive) value, use ABS[^] function:

SELECT ABS(DATEDIFF(DAY, MIN([startdate]),MAX([enddate])) AS NumberOfDays from tablename


                        
这篇关于计算日期时间之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！