select t.Period_Id,t.Period_Name,
LTRIM(RIGHT(CONVERT(VARCHAR(20), t.PeriodStarttime, 100), 7)) AS PeriodStarttime,
LTRIM(RIGHT(CONVERT(VARCHAR(20), t.PeriodEndtime, 100), 7)) AS PeriodEndtime
from tbl_TimetablePeriod as t
MAY BE IT WILL HELP YOU
Period_Id Period_Name PeriodStarttime PeriodEndtime
1 A 2:15AM 2:15AM
2 B 4:15AM 5:15AM
3 C 5:15PM 6:15PM