Date TIme Format in sql

Question

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

Bikesh Srivastava · Answer

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 Patel · Answer

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 T P · Answer

Hi please try below query - select convert(varchar(5)colname108) as [time] from yourtable

Nitin Sontakke · Answer

Please refer to the following link this has all available formats listed: https://msdn.microsoft.com/en-IN/library/ms187928.aspx