UDF For Extracting Actual Time From Two DateTime

Hi guys,       I have created a script of User-Defined-Function to extract the calulated time from two given datetime inputs. But you have to pass THREE parameters like :-a)Start Datetimeb)End Datetimec)To display the format either in HH:MM:SS or HH.MM , we    use 'T'(HH:MM:SS) OR 'N'(HH.MM).   Please feel FREE to E-mail me at […]

2004-01-14

118 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Printing the String

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Printing the String

how to list index corresponding to statistics using select statement

By ebooklub

Hi , with query bellow I  can list DTA  statistic that is not updated...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers