我想要一个仅在HOUR中显示时间的查询 [英] I want a query that will show time only in HOUR

问题描述

我在存储过程中使用以下查询，该查询以hpus，分，秒格式显示时间....

SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20)，GETDATE()，100)，7))

...
我想要一个仅以HOUR(12小时格式)显示时间的查询...(例如5AM)

预先感谢thanx

i m using the following query in my store procedure that is showing the time in hpus,minute, second format....

SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GETDATE(), 100), 7))

...
I want a query that will show time only in HOUR (12 hour format)...(EX. 5AM)

thanx in advance

推荐答案

SELECT CASE WHEN DATEPART( HH , GETDATE()) > 12 THEN CAST ( ( DATEPART( HH , GETDATE())  % 12 ) AS VARCHAR) + ' PM'
            ELSE  CAST ( ( DATEPART( HH , GETDATE())   ) AS VARCHAR) + 'AM'
        END AS HourParam

u可以尝试一下也是这样.

u may try it this way too..

SELECT substring((CONVERT(varchar(20),GETDATE(), 100)),14,(len(CONVERT(varchar(12),GETDATE(), 100)))) 

希望对您有帮助.

thanx

hope this help u..

thanx

我认为您可以执行类似的操作，使您正在使用的查询给您05:00 am，然后您可以使用子字符串来获得所需的结果.

i think you can do something like that the query you are using gives you 05:00am then you can use substring to get your desired result.

这篇关于我想要一个仅在HOUR中显示时间的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！