How to select date within two dates from database SQL function

Question

0.00/5 (No votes)

See more:

I am Selecting the Data within two date start_date and End_date,
Start_date and End_date in between dates are not Existing in database.
how to get date within two dates.

What I have tried:

select STATUS,SELECT_DATE from PA_TIME_SCHEDULING_table where 
              SELECT_DATE between '2018/04/17' and '2018/04/19'

Posted 18-Apr-18 12:25pm

Sanjeev Kumar

Updated 18-Apr-18 17:23pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

an0ther1 · Answer 1 · 2018-04-18T13:50:00

One method of achieving this is as follows;
NOTE: The following is just a demonstration of how it can be achieved and will need to be edited for your requirements

SQL

DECLARE @dteStart DATETIME
DECLARE @dteEnd DATETIME

SET @dteStart = '20180501'
SET @dteEnd = '20180514'

CREATE TABLE #TempDates
(
	[TheDate] DATETIME
)

WHILE @dteStart < DATEADD(day, 1, @dteEnd)
BEGIN
	INSERT INTO #TempDates([TheDate]) VALUES(@dteStart)
	SET @dteStart = DATEADD(day, 1, @dteStart)
END

SELECT * FROM #TempDates

DROP TABLE #TempDates

Kind Regards

Wendelius · Answer 2 · 2018-04-18T17:24:00

If the SELECT_DATE is stored as a date in PA_TIME_SCHEDULING_table try explicitly converting the start and end dates to date. You should never trust on implicit conversion since it's affected by database settings,

For example

SQL

select STATUS,SELECT_DATE 
from PA_TIME_SCHEDULING_table where 
SELECT_DATE between convert(date, '2018/04/17', 111) and convert(date, '2018/04/19', 111)

If the SELECT_DATE is stored as a varchar, then you could achieve the correct result by converting it into a date in the where clause, but instead of doing that, I would recommend changing the data type into date.

How to select date within two dates from database SQL function

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0