Posts by Adriano Carvalho • 1 point
1 post
-
0
votes1
answer1246
viewsA: Sql server convert String time to Decimal
You can divide the value by 86400 which is the amount of seconds in the day, but before that should convert to seconds follows a complete example: Declare @data As Datetime = '08:00:00' ,@H As Float…