我写了以下查询：

SELECT CASE WHEN rpwh.StartDayOfTheWeek = 1 THEN 7
WHEN rpwh.StartDayOfTheWeek = 2 THEN 1 
WHEN rpwh.StartDayOfTheWeek = 3 THEN 2 
WHEN rpwh.StartDayOfTheWeek = 4 THEN 3 
WHEN rpwh.StartDayOfTheWeek = 5 THEN 4 
WHEN rpwh.StartDayOfTheWeek = 6 THEN 5 
WHEN rpwh.StartDayOfTheWeek = 7 THEN 6
END AS StartDayOfTheWeek,DATENAME(WEEKDAY,rpwh.StartDayOfTheWeek - 2) DayOfTheWeek,rpwh.StartAt,rpwh.EndAt
FROM ResourceProfileWorkingHours rpwh
JOIN ResourceProfile rp ON rpwh.ResourceProfileId = rp.Id
WHERE rp.Alias = 'accounts Payable'
ORDER BY StartDayOfTheWeek

哪个返回：

StartDayOfTheWeek   DayOfTheWeek    StartAt              EndAt
1                   Monday          09:00:00.0000000     17:00:00.0000000
2                   Tuesday         09:00:00.0000000     17:00:00.0000000
3                   Wednesday       09:00:00.0000000     17:00:00.0000000
4                   Thursday        09:00:00.0000000     17:00:00.0000000
5                   Friday          09:00:00.0000000     17:00:00.0000000
6                   Saturday        09:00:00.0000000     17:00:00.0000000
7                   Sunday          09:00:00.0000000     17:00:00.0000000

我需要将StartAt时间转换为9:00，将EndAt时间转换为17:00。我尝试编写下面的行，但是当我运行它时，两列的值都为空。我该怎么办？

FORMAT(rpwh.StartAt,'hh:mm') AS StartTime,FORMAT(rpwh.EndAt,'hh:mm') AS EndTime