Business Time in Seconds Function

SQL Function to calculate number of business seconds between 2 datetime fields. Input Parameters: @startdate - Start Time (datatype DateTime) @enddate - End Time (datatype DateTime) @starthour - Start of Business Day (datatype DateTime) (Format: '1900-01-01 9:00:00') @endhour - End of Business Day (datatype DateTime) (Format: '1900-01-01 17:00:00') @workdays - Business Day string - Use […]

2006-03-15 (first published: )

228 reads

Blogs

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

Read the latest Blogs

Forums

Why are DBAs not paid for knowledge and other IT Professionals are?

By Engineer

DBAs are being asked to know everything for 6 figures which cap out for...

Common Table Expression Misunderstandings

By Kathi Kellenberger

Comments posted to this topic are about the item Common Table Expression Misunderstandings

Distributed AG DB movement

By Syed_SQLDBA

I have a DAG between On prem and Azure. We have a maintenance window...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers