Im pretty new to SQL SERVER and Im trying to make some select with datesTable DatesStartDateEndDate05012021100120212001202125012021There are 2 DATETIME pickers that the user can choose forI would like to ask gt If a user picks StartDate 06012021 and EndDate 08012021 how could i know that they are not available days because I already have 05012021 to 10012021Here is what I tryiedSELECT FROM MyDBdboDates WHERE CASTStartDate as date gt 390601202139 ANDCAST

Hi themiteCheck with below querySQLDECLARE Test AS TABLEStartDate DATEEndDate DATEINSERT INTO Test VALUES390105202139390110202139INSERT INTO Test VALUES390120202139390125202139DECLARE From DATETo DATESET From 390106202139SET To 390108202139SELECT FROM TestWHERE From BETWEEN CASTStartDate AS DATE AND CASTEndDate AS DATEAND To BETWEEN CASTStartDate AS DATE AND CASTEndDate AS DATE

Select available Date for appointment in SQL Server

themite

SOLVED CLOSED ACTIVE ANSWERED
User: themite
Posted: on Jan 29, 2021 10:23 PM
Forum: SQL Server
Answer: 1
Views: 1478

I'm pretty new to SQL SERVER and I'm trying to make some select with dates.

Table Dates

StartDate	EndDate
05/01/2021	10/01/2021
20/01/2021	25/01/2021

There are 2 DATETIME pickers that the user can choose for

I would like to ask --> If a user picks StartDate 06/01/2021 and EndDate 08/01/2021

how could i know that they are not available days because I already have 05/01/2021 to 10/01/2021.

Here is what I tryied

SELECT * FROM MyDB.dbo.Dates WHERE CAST([StartDate] as date) >= '06/01/2021' AND
CAST([EndDate] as date) <= '08/01/2021'

But I get 0 records because I didn't write it good I guess, if someone could help me to think of about it would be very appreciated (if you find something missing I would be happy to help).

Thank you

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Jan 30, 2021 04:59 AM
Report

Hi themite,

Check with below query.

SQL

DECLARE @Test AS TABLE(StartDate DATE,EndDate DATE)
INSERT INTO @Test VALUES('01/05/2021','01/10/2021')
INSERT INTO @Test VALUES('01/20/2021','01/25/2021')
DECLARE @From DATE,@To DATE
SET @From = '01/06/2021'
SET @To = '01/08/2021'
SELECT * 
FROM @Test
WHERE (@From BETWEEN CAST([StartDate] AS DATE) AND CAST([EndDate] AS DATE))
AND (@To BETWEEN CAST([StartDate] AS DATE) AND CAST([EndDate] AS DATE))

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Select available Date for appointment in SQL Server

Company

Explore

Follow us

Contact Us