Difference Between Two Times

[lfcmd]

If i have two time fields stored as type nvarchar
how can i find the differnce in time between the 2

time
12:02
12:38

returning 0:36

 

[macleod1021]

DATEDIFF ( datepart , startdate , enddate )

 

[jbenson001]

you would have to convert them to a valid datetime format then use the datediff function.

 

[lfcmd]

cheers guys

 

[vongrunt]

This should work for positive values < 24h:

select convert(varchar(5), convert(datetime, '12:38') - '12:02', 108)

But [!]n[/!]varchar... .

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]