Time range between two times

Question

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

Rajkiran Swain · Answer

SELECT * FROM `table` WHERE CAST( '05:00:00' AS time) BETWEEN `start` AND `end` OR (NOT CAST( '05:00:00' AS time) BETWEEN `end` AND `start` AND `start` > `end`)

Midhun T P · Answer

Hi Please try below query - SELECT CONVERT ( varchar (12)DATEADD( minute  datediff(mistarttimeendtime) 0) 114) FROM yourtable

Sudarvizhi J · Answer

Thanks its working

Sudarvizhi J · Answer

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

Rajkiran Swain · Answer

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