Convert Time to 0015 format Sql

Question

I want to Convert time to 0000 format. I'm using SQL Server 2017.

I've written the following query :

SELECT EventName, Convert(time, EventTime) as 'Log out' 
From AttendanceEvents

Which gives:

The Format I want my Time to be is :

and So on..

The `time` type doesn't *have* a format. So converting something *to* that type isn't going to do what you want. Which version of SQL Server are you using? — Damien_The_Unbeliever, Oct 05 '18 at 07:15
Which DBMS? Are you using SSMS on a SQL Server database? Or Azure? Or another DBMS still? — Thorsten Kettner, Oct 05 '18 at 07:16

D-Shih · Accepted Answer · 2018-10-05T07:32:08.257

2

You can try to use CONVERT third parameter set 108 will get a hh:mi:ss string, then get front 5 characters and REPLACE :.

SELECT REPLACE(CONVERT(varchar(5), EventTime, 108), ':', '')

or use FORMAT function.

SELECT FORMAT(GETDATE(),'hhmm')

Query 1:

SELECT FORMAT(GETDATE(),'hhmm')

SELECT REPLACE(CONVERT(varchar(5), GETDATE(), 108), ':', '')

|      |
|------|
| 0718 |

edited Oct 05 '18 at 07:32

answered Oct 05 '18 at 07:16

D-Shih

Thanks! But what does this 108 implies? – Dawood Zaidi Oct 05 '18 at 07:29
@DawoodAbbas I add a link to msdn, `Convert` 108 will get a string `hh:mi:ss` – D-Shih Oct 05 '18 at 07:32

1 Answers1