Time range between two times

Sudarvizhi J

9y952

Sql server how to select time range between two columns times. Can any one explain how to do ASAP

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hi,

Please try below query -

SELECT CONVERT(varchar(12),DATEADD(minute, datediff(mi,starttime,endtime), 0), 114) FROM yourtable

Thanks its working

Thanks for your replay. we have used two time field in db like starttime and endtime. how to compare between two times

SELECT * FROM MyTable WHERE DATEPART(HOUR, SyncDate) = 14 AND DATEPART(MINUTE, SyncDate) BETWEEN 0 AND 30