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

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

A New Git Default Branch

By

I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...

Read the latest Blogs

Forums

xp_cmdshell

By ramyours2003

how to check which job or  stored procedure using xp_cmdshell in sql server ?

consolidate error logs

By ramyours2003

i need to configure job to consolidate sql error log sizes   from multiple servers...

How to write update query to check exist column by value 1 where it exist on tab

By ahmed_elbarbary.2010

How to update check exist column by value 1 where partid exist on table...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers