How can i convert 24
hour formatted time into 12
hour formatted time in SQL server 2008?
We can use DATEPART() function to get the HOUR part of the DateTime in Sql Server, here we need to specify datepart parameter of the DATEPART function as hour or hh.
For example if the time in 12 hour clock is 11:00 PM, then the time in 24 hour clock is 11:00 + 12:00 = 23:00 hours.
Change Time format to HH:mm:ss for a 24-hour clock. Change Time format to hh:mm:ss tt for a 12-hour clock.
Do you have the current time in a variable/column of type time? If so, it's easy:
declare @t time
set @t = '14:40'
select CONVERT(varchar(15),@t,100)
result:
2:40PM
If it's in a datetime(2)
variable, then you'll have to strip out the date portion after running the CONVERT. If it's in a string, then first CONVERT
it to time
, then use the above code.
Sometimes you need to do it inline:
SELECT CONVERT(varchar(15), CAST(GETDATE() AS TIME), 100) as AmPmTime
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With