转换datetime sql [英] converting datetime sql

问题描述

我正在使用此查询显示日期时间，我只想使用此但问题是它提供24小时格式的时间，如16：30,17：55，但我想使用12小时格式，如$; 30， 05:55

i am using this query to display datetime and i only want to use this but problem is that it gives times in 24 hours format like 16:30, 17:55 but i want to use 12 hours format like $;30, 05:55

SELECT [ID],REPLACE(convert(varchar, ReceivedMessages.ReceivedDateTime, 113), ' ','/') as RecievingDate FROM [CmsSMSDb].[dbo].[ReceivedMessages]

推荐答案

; 30，05：55

;30, 05:55

SELECT [ID],REPLACE(convert(varchar, ReceivedMessages.ReceivedDateTime, 113), ' ','/') as RecievingDate FROM [CmsSMSDb].[dbo].[ReceivedMessages]

113告诉转换使用24小时格式。

如果如果您使用109，您将获得12小时格式的上午/下午。



有关详细信息，请参阅此链接：



http://msdn.microsoft.com/en-us/library/ms187928.aspx [ ^ ]

The 113 tells the convert to use a 24 hour format.
If you use 109, you will get a 12 hour format with AM/PM.

See this link for further details:

http://msdn.microsoft.com/en-us/library/ms187928.aspx[^]

SELECT REPLACE(SUBSTRING(convert(varchar, getdate(), 113),0,12),' ','/')+
        SUBSTRING(RIGHT(CONVERT(VARCHAR(26), GETDATE(), 109),14),0,6) AS TEST1

SELECT REPLACE(SUBSTRING(convert(varchar, getdate(), 113),0,12),' ','/')+
        RIGHT(CONVERT(VARCHAR(26), GETDATE(), 109),14) AS TEST2

- 只需用上面的查询替换getdate

--Just replace getdate in above query with

ReceivedMessages.ReceivedDateTime

--TEST1将在没有AM / PM的情况下输出TEST2将AM / PM附加到日期

--TEST1 will give output without AM/PM whereas TEST2 will append AM/PM to the date

这篇关于转换datetime sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！