Reputation: 2250
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
Reputation: 285
Simplest Code:
SELECT CONVERT(VARCHAR(5),CAST(GETDATE() AS TIME), 108)
Upvotes: 2
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
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
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
Reputation: 1018
And to do it by SQL:
SELECT FORMAT( getdate(), 'HH:mm', 'en-US' )
Upvotes: 3