Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Solved
Calculate SQL Server Date Range
Posted on 2011-09-15
I have a table with the following schema:
EmployeeID int
StartDate smalldatetime
EndDate smalldatetime
One record in this table contatis the following data:
ID StartDate EndDate
1 2010-11-30 2011-05-16
I need to know if the Strat/End Date record is between a range, for example '2011-04-16' and '2011-05-15'.
How can I achieve this with SQL Server ?
EmployeeID int
StartDate smalldatetime
EndDate smalldatetime
One record in this table contatis the following data:
ID StartDate EndDate
1 2010-11-30 2011-05-16
I need to know if the Strat/End Date record is between a range, for example '2011-04-16' and '2011-05-15'.
How can I achieve this with SQL Server ?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
select *
from tablename
where startdate between '2011-04-16' and '2011-05-15'
or enddate between '2011-04-16' and '2011-05-15'
from tablename
where startdate between '2011-04-16' and '2011-05-15'
or enddate between '2011-04-16' and '2011-05-15'
This will not work for me. What I need is to calculate if the employee is out of work in the period specified (in this case he started in medical license in 2010-11-30 and ended in 2011-05-16).
I need to ensure that in the period from '2011-04-16' until '2011-05-15' he was in medical license. If I use your approach (which was what I´m using today) the program will not works fine!
Thanks in advance
I need to ensure that in the period from '2011-04-16' until '2011-05-15' he was in medical license. If I use your approach (which was what I´m using today) the program will not works fine!
Thanks in advance
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month9 days, 15 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.