sql - FORMAT([Time], 'hh:mm' ) 返回 NULL

Question

我有一个日历表 with the following structure :

CalendarID    nvarchar(13)
Date          date
Time          time(7)

数据如下:

将时间列格式化为 hhmm 有效:

SELECT [CalendarID]
     , FORMAT([Date], 'ddd, MMM dd, yyyy') AS [DATE]
     , FORMAT([Time], 'hhmm') AS [Time]
FROM [dbo].[Calendar]

但格式化为 hh:mm 不起作用并显示 NULL:

SELECT [CalendarID]
     , FORMAT([Date], 'ddd, MMM dd, yyyy') AS [DATE]
     , FORMAT([Time], 'hh:mm') AS [Time]
FROM [dbo].[Calendar]

如何将其格式化为hh:mm？

Answer 1

这样试试:

FORMAT([Time], N'hhmm') AS [Time]

或

FORMAT([Time], N'hh\:mm') AS [Time]