how to find timeDifferece in two columns

Hi friend,

this will help you...

DECLARE @A DATETIME
DECLARE @B DATETIME
DECLARE @Secs DECIMAL(18, 2)

SET @A = '2005-08-06 12:08:00.000'
SET @B = '2005-08-18 00:30:19.000'

SELECT @Secs = DATEDIFF(s, @A, @B) / 60.000000 / 60.00000 / 24.000000
select @Secs

Dear Dinesh,
Hope this will help you.

select DATEDIFF(day,col1,col2) AS NumberOfDays,
DATEDIFF(hour,col1,col2) AS NumberOfHours,
DATEDIFF(minute,col1,col2) AS NumberOfMinutes FROM Your_Table

select DATEDIFF(day,2012-06-19,2012-06-20) AS NumberOfDays,
DATEDIFF(hour,2012-06-19,2012-06-20) AS NumberOfHours,
DATEDIFF(minute,2012-06-19,2012-06-20) AS NumberOfMinutes FROM Your_Table

Regards,
AP

Hi
Try this

SELECT Format(j.Leaving_time - j.Arrival_Time, "hh:nn:ss") AS Time_Difference
FROM Technicians AS t, Jobs AS j, Tech_Allocation AS ta
WHERE j.Job_ID = ta.Job_ID     
  AND ta.Technician_ID = t.Technician_ID
ORDER BY 1 ASC;

Beware, this approach is only valid for Time_Differences less than 24 hours
This is easier way to find difference
You can also use "DateDiff" function for subtraction
DateDiff[^]
DateDiff Approach is the best way.

Hi ,
Check this using DATEDIFF

declare @t1 time
set @t1 ='10:00'
declare @t2 time
set @t2 ='10:30'

select DATEDIFF( MI ,@t1 ,@t2)

Best regards
M.Mitwalli