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: )

220 reads

Blogs

How I passed the 70-761 certification exam

By

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Read the latest Blogs

Forums

how about explaining your RegEx logic?

By jeffrey yao

RegEx is always tough to digest (without referring to document), so it would be...

Relatively easy query assistance - datediff

By morkal

Hi all, I have a question since I'm new to SQL: I have a...

Mirroring alerts

By kilein

Hi, In one of our customers the database mirroring was already configured. After long...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers