Thursday, 31 March 2011

SQl Date Difference Between two Dates

Declare @Fromdate datetime
Declare @Todate datetime
Declare @TopID int
Declare @Duration int

Select top 1 @TopID= LeaveId from dbo.LeaveDetails order by LeaveId desc

select @Fromdate= convert(varchar,FromDate,103) from dbo.LeaveDetails  where LeaveId=@TopID

select @Todate = convert(varchar,ToDate,103) from dbo.LeaveDetails  where LeaveId=@TopID

SELECT @Duration=DATEDIFF(dd, @Fromdate,@Todate)

No comments:

Post a Comment