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

Your First Jupyter Notebook

By

In April, I said I was going to start learning Jupyter Notebooks. It’s November....

Using Visual Studio Code

By

I’m a creature of habit. I have my routine when I get to my...

Docker Containers and Persistent Data

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

SSRS Enterprise vs Standard Edition

By TUellner

I need to install SSRS for report development and deployment. I don't work with...

Suspended session

By IMary

Hi, Application service is going to hung state and when we check the database,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers