Aetherix
Aetherix

Reputation: 2250

SQL Server 2008: display time in hh:mm format

I have a time field in a table that I would like to display in a view in hh:mm format. What is the easiest way to do this?

Upvotes: 5

Views: 57185

Answers (5)

Divya Agrawal
Divya Agrawal

Reputation: 285

Simplest Code:

 SELECT CONVERT(VARCHAR(5),CAST(GETDATE() AS TIME), 108)

Upvotes: 2

Rock
Rock

Reputation: 584

SELECT LEFT(CONVERT(VARCHAR(5),@Regdate,108),5) 

Or

SELECT COUNT(Id)FROM Students Where CONVERT(VARCHAR(5),RegDate,108)=CONVERT(VARCHAR(5),@Regdate,108)

Upvotes: 1

Yasir Majeed
Yasir Majeed

Reputation: 741

SELECT convert(varchar, getdate(), 108) – hh:mm:ss

OR

SELECT convert(varchar, getdate(), 113) – dd mon yyyy hh:mm:ss:mmm

Upvotes: 0

M.Ali
M.Ali

Reputation: 69524

SELECT CONVERT(VARCHAR(5), GETDATE(), 108)

RESULT:  13:19

For Time values

DECLARE @TimeField TIME = CAST(GETDATE() AS TIME);

SELECT CONVERT(VARCHAR(5), @TimeField, 108)

RESULT:  13:21

Upvotes: 15

Thomas Krojer
Thomas Krojer

Reputation: 1018

And to do it by SQL:

SELECT FORMAT( getdate(), 'HH:mm', 'en-US' ) 

Upvotes: 3

Related Questions