How do start time and end time without date sql server
Hi,I am trying to solve this sql query. But my sql query is giving wrong count..
in table i have time column which depend upon for query.
Out client office time is :
07:30:00 am to 23:59:59 pm
and night 00:00:00 am to 07:59:59 am
following query how to do this because i am getting wrong count..
1)
Select COUNT(*)
From TEMP_VEHICLE_MASTER_2017 V
Inner Join TOLL_MASTER T On V.TOLL_ID = T.TOLL_ID
Inner Join PROJECT_MASTER P On T.PROJECT_ID = P.ID
Inner Join VEHICLE_TYPE_MASTER VTM On VTM.ID = V.TYPE_ID
Inner Join TEMP_VEHICLE_TICKET_DETAIL_2017 VT On V.VEHICLE_ID = VT.TICKET_ID And V.TOLL_ID = VT.TOLL_ID
Where V.TOLL_ID = '102001'
And ((Cast(V.TIME as datetime) >= '07:30:00' And Cast(V.TIME as datetime) <= '23:59:59')
OR (Cast(V.TIME as datetime) >= '00:00:00' And Cast(V.TIME as datetime) <= '07:29:59'))
2) following query how to do this beacause i am getting right count..
but i want add (Cast(V.TIME as datetime) >= '00:00:00' And Cast(V.TIME as datetime) <= '07:29:59'))
so how to do
Select COUNT(*)
From TEMP_VEHICLE_MASTER_2017 V
Inner Join TOLL_MASTER T On V.TOLL_ID = T.TOLL_ID
Inner Join PROJECT_MASTER P On T.PROJECT_ID = P.ID
Inner Join VEHICLE_TYPE_MASTER VTM On VTM.ID = V.TYPE_ID
Inner Join TEMP_VEHICLE_TICKET_DETAIL_2017 VT On V.VEHICLE_ID = VT.TICKET_ID And V.TOLL_ID = VT.TOLL_ID
Where V.TOLL_ID = '102001'
And (Cast(V.TIME as datetime) >= '07:30:00' And Cast(V.TIME as datetime) <= '23:59:59')