Time Example

SELECT distinct td.[CandidateID]

,pc.Description AS Province

,Year(td.Start)

,Day(td.Start)

,cast(td.[Start] as time) [time]

,cast(td.[End] as time) [time]

FROM [hjklhj].[dbo].[TimesheetDetail] AS td

INNER JOIN [jkljkh].[dbo].[Candidate] AS cd on td.CandidateID = cd.CandidateID

INNER JOIN [hjlhhhj].[dbo].[Province] AS pc on cd.ProvinceID = pc.Id

WHERE pc.Description = 'CB070000-CPT'

AND Year(Start) = '2021'

AND Month(Start) = '01'

MSSQL