Deepak M

Deepak M

  • 1.2k
  • 546
  • 36.8k

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

Dec 30 2022 6:44 AM

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)