Date TIme Format in sql

Abhishek Chadha

10y1.2kSQL

I want to convert my date time format in sql to 24 hr time

in short i want time (24 hr format) from datetime column

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hi,

Its working fine..

Example -

Query (24 hour format):

Select Format(cast('2016-03-03 23:59:59' as datetime),'dd-MMM-yyyy HH:mm:ss','en-us'). ('HH:mm:ss' in Capital letters)

Result

03-Mar-2016 23:59:59

Tapan Patel10y ago
Go to below link where you will find all possible date time formats for SQL and choose any of them.
http://www.sql-server-helper.com/tips/date-formats.aspx
Midhun Tp10y ago
Hi, please try below query -
select convert(varchar(5),colname,108) as [time] from yourtable
Nitin Sontakke10y ago
Please refer to the following link, this has all available formats listed:
https://msdn.microsoft.com/en-IN/library/ms187928.aspx