How can I convert 3:00 to 3 in SQL Server ?

C# Corner

Deepak M

3y1.3kSQL Server

Hello,
How can I convert time HH:MM format to decimal format ?
for ex

3:00 to 3
3:15 to 3.25
3:30 to 3.5
3:45 to 3.75

Can any one help?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pasang Tamang3y ago
Accepted answer
Hi Deepak,

You can use DATEPART function to extract hour and minute separately and make the calculation. Check below SQL code for your reference.
```
Declare @dateTimeValue VARCHAR(10) = '03:15'
SELECT CAST(DATEPART(hour, @dateTimeValue)+DATEPART(minute, @dateTimeValue) / 60.00 AS DECIMAL(7,4))
```
Regards,
Pasang
+3

Amit Mohanty3y ago

Check this

Declare @yourValue VARCHAR(50) = '08:30'
(SELECT CAST(LEFT(@yourValue, PATINDEX('%[:.]%', @yourValue) - 1) AS INT) + 
CAST(RIGHT(@yourValue, PATINDEX('%[:.]%', REVERSE(@yourValue)) -1 ) AS INT) / 60.0)