Check if a time is between two times (time DataType)

I suspect you want to check that it’s after 11pm or before 7am:

select *
from MyTable
where CAST(Created as time) >= '23:00:00' 
   or CAST(Created as time) < '07:00:00'