time format in SQL Server

user_52745 0
Viewed 78301

Does anyone know how can I format a select statement datetime value to only display time in SQL Server?

example:

Table cuatomer
id   name   datetime
1    Alvin  2010-10-15 15:12:54:00
2    Ken    2010-10-08 09:23:56:00

When I select the table I like the result will display as below

id   name    time
1    Alvin   3:12PM
2    Ken     9:23AM

Any way that I can do it in mssql?

time tsql sql-server
7 Answers

If you are using MySql you can use TIME_FORMAT()

Code ↓↓

SELECT name, time_format(datatime,'%H:%i') as tine from cuatomer
user_112588660

If You are using SQL Server 2008 or Higher You can use the following statement:

SELECT Convert( VarChar( 10 ), CAST([columnName] AS TIME(0)), 100 )
user_76362390
Related