Working Hours

Technical Article

Calculating Working Hours

  • Script

Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.

(3)

You rated this post out of 5. Change rating

2015-10-22 (first published: )

3,749 reads

Blogs

A Daily Report from Claude

By

Redgate had some Claude training recently, which I went through as my knowledge has...

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Read the latest Blogs

Forums

Demo Tracking Dropped Objects

By Artur Sanin

Comments posted to this topic are about the item Demo Tracking Dropped Objects

Randomly Selecting Columns and Rows from a Table or View

By Artur Sanin

Comments posted to this topic are about the item Randomly Selecting Columns and Rows...

How Can SQL Server Detect Application Errors When Developers Can’t?

By Pablo Echeverria

Comments posted to this topic are about the item How Can SQL Server Detect...

Visit the forum

Question of the Day

Getting Database MaiL Profiles

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?

See possible answers