2
Answers

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

Deepak M

Deepak M

2y
866
1

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?

Answers (2)