Make a time value from a given float value

Clients asked me to show a more detailed and longer text which doesn't have to be edited. So I came up with the following solution/function.This function returns a varchar time value with a description containing how many days, hours and minutes. For example 100.25 returns :'100:15( 4 Days, 4 Hours, 15 Minutes )'.I hope somebody […]

2007-07-04 (first published: )

107 reads

Blogs

Captioning Options for Your Online Conference

By

Many conferences have moved online this year due to the pandemic, and many attendees...

Daily Coping 24 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Virtual Log Files

By

Today’s post is a guest article from a friend of Dallas DBAs, writer, and...

Read the latest Blogs

Forums

Variable Based on Variable in Paginated Report w/ Native Oracle Connection

By dataanalystanonymous

I have an SSRS paginated report where users need the ability to pick and...

IndicatorsPool events causing memory pressure?

By Ian (SSC)

Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...

Sql Server Specs Question

By smattiko83

Hi, I have two different servers that I do a bulk insert on the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers