This article is the first in a series that lists date functions and date manipulation calculations for leading database systems and this article looks at the first of those — Microsoft SQL Server. Please refer to the other articles in this series on DB2 and Oracle.

SQL Server Reference.

SQL SERVER - Working with Business Days in SQL Server - A Different Approach - SQL Authority with Pinal Dave

Note, this will return the date and time according to the servers timezone. Use getUTCDate to return the date and time in universal time coordinates.

The above formula will all use Sunday as the first day of the week by default. To use Monday as first day of the week alter the value of the last digit to use another day.

There are several articles that can be found on the net that discuss the above formula, I got most of these examples above from the calculate business days between two dates sql server article by Gregory A.

I was wondering if you could explain how the First day of eli5 stock options week example works, breaking this down the datediff wk, 7, getdate section returns the valueI was just wondering how returning this result and using within the select dateadd wk, datediff wk, 7, getdate0 statement actually works as I always thought the syntax required only dates.

What is the significance of ?

sql - Calculate total business working days between two dates - Stack Overflow

The datediff formula calculates the number of periods between two dates. Here we calculate the difference in weeks between the today getdate and the 7th day since start of the calendar.

Note this is one less than number of weeks between 1st day in calendar and today. We then add this number of weeks to the first day of the calendar with dateadd wk,0 so weeks since 0 day will be first day of last week.

Thats extremely helpful, many thanks for explaining this! The main reason I needed to understand this process is that I need to translate this same situation in VB.

You must be logged in to post a comment. Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Business Intelligence Articles from www. Date Maths — SQL Server 3 Replies. SQL Server Reference SQL Server Reference SQL Server Reference System Date GETDATE Note, this will return the date and time according to the servers timezone.

Leave a Reply Cancel reply You must be logged in to post a comment.