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,737 reads

Blogs

SQL Training Black Friday Deals

By

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files?

By

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

Happy Thanksgiving! (USA Holiday)

By

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Read the latest Blogs

Forums

FinOps - the new name for performance tuning

By John Martin

Comments posted to this topic are about the item FinOps - the new name...

Which Object Definitions Are Available?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Which Object Definitions Are Available?

What's Your Theme Music?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's Your Theme Music?

Visit the forum

Question of the Day

Which Object Definitions Are Available?

For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)

See possible answers