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'