忽略日期部分并从SQL中的datetime列获取时间部分?

问题描述：

我有一个问题，我想使用日期时间" SQL列中的时间"部分.

请任何人帮助我！

谢谢.

Hi,

I have a problem, i want to use Time part from my Date Time SQL Column.

Kindly anyone please hep me!

Thanks .

答

EASILY在Google上找到.您可以将以下代码放入Sql函数中:

EASILY found on google. You could put this code into a Sql function if you want to:

CONVERT(char(10), MyDateTime, 101) AS [Date],
     CONVERT(varchar(2),
          CASE
               WHEN DATEPART([hour], MyDateTime) > 12 THEN CONVERT(varchar(2), (DATEPART([hour], MyDateTime) - 12))
               WHEN DATEPART([hour], MyDateTime) = 0 THEN '12'
               ELSE CONVERT(varchar(2), DATEPART([hour], MyDateTime))
          END
     ) + ':' +
     CONVERT(char(2), SUBSTRING(CONVERT(char(5), MyDateTime, 108), 4, 2)) + ' ' + 
     CONVERT(varchar(2),
          CASE
               WHEN DATEPART([hour], MyDateTime) > 12 THEN 'PM'
               ELSE 'AM'
          END
     )

您可以使用

SELECT CONVERT(VARCHAR(10),DATE_FIELD,108)

SELECT     CONVERT(nvarchar(50), 'COLUMNNAME', 114) AS Time
FROM         'TABLENAME'

忽略日期部分并从SQL中的datetime列获取时间部分?

相关推荐