Technical Article

UDF to convert Seconds to DDD:MM:MM:SS Format

This function takes a number of Seconds in BIGINT format and calculations and displays that in a DDD:HH:MM:SS format.I wrote this because I needed to work out the duration between two datetimes and required the result to be displayed in a Report (VARCHAR (12)) format from a Select statementTo Use:SELECT dbo.csp_SecondsToDaysHoursMinutesSeconds(DATEDIFF(SS, , ))  AS DurationFROM […]

You rated this post out of 5. Change rating

2002-05-09

320 reads

Blogs

Building Effective Data Governance Framework: Top Areas to Focus On

By

The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...

Master the Foundational Basics

By

It tells us to take the time to master the foundational basics of whatever...

Simple Talks Episode 9–Data masking and subsetting

By

The episode on data masking and subetting is out. You can see it here:...

Read the latest Blogs

Forums

Looking for Commercial Kitchen Equipment Manufacturers?

By bhartirefwork

Bharti Refrigeration Works is a leading manufacturers of commercial kitchen equipment. Find reliable solutions...

How To Book Southwest Airlines Group Travel Booking?

By southwestfareway

Southwest Airlines offers specialized group travel services, making it easy for groups of 10...

Nutrim

By nutrimerfahrungen

Nutrim Kapseln sind ein beliebtes Nahrungsergänzungsmittel zur Gewichtsreduktion. Sie enthalten natürliche Inhaltsstoffe wie Appetitzügler,...

Visit the forum

Question of the Day

The Hash Join I

What are the two inputs called to a hash join operation in SQL Server? (choose 2)

See possible answers