Using query get date for today date and tomorrow date

narasiman rao

Select * from Coursedetails

Courseid Coursename CourseType Coursedate Active

1 REO Revalidation 2016-08-28 00:00:00.000 A
2 RM Deck 2016-08-28 00:00:00.000 A
3 AFF Advance 2016-08-28 00:00:00.000 A
4 TFC Tanker 2016-08-28 00:00:00.000 A

5 CTF Tanker 2016-08-29 00:00:00.000 A
6 AMOS Deck 2016-08-29 00:00:00.000 A
7 MFA Advance 2016-08-29 00:00:00.000 A
8 DFC Tanker 2016-08-29 00:00:00.000 A

9 ECDIS Tanker 2016-08-30 00:00:00.000 A
10 GP Deck 2016-08-30 00:00:00.000 A
11 DME Advance 2016-08-30 00:00:00.000 A
12 DFC Tanker 2016-08-30 00:00:00.000 A

When i run the above query Select * from Coursedetails. the above output i get.

I want the output as Course date 28th and 29th date only.

Select * from Coursedetails

Courseid Coursename CourseType Coursedate Active

1 REO Revalidation 2016-08-28 00:00:00.000 A
2 RM Deck 2016-08-28 00:00:00.000 A
3 AFF Advance 2016-08-28 00:00:00.000 A
4 TFC Tanker 2016-08-28 00:00:00.000 A

5 CTF Tanker 2016-08-29 00:00:00.000 A
6 AMOS Deck 2016-08-29 00:00:00.000 A
7 MFA Advance 2016-08-29 00:00:00.000 A
8 DFC Tanker 2016-08-29 00:00:00.000 A

for getting query what changes i need to be my select statement Query

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

ketan borsdiya10y ago
Hi Narasiman,
Use below Query,
Declare @date as datetime='2016-08-29'
select * from Coursedetails where DATEDIFF(DAY,Coursedate,@date)=0
Union all
select * from Coursedetails where DATEDIFF(DAY,Coursedate,@date-1)=0
Bikesh Srivastava10y ago
Hi,
try this..
declare@datefromdatetime
declare@datetodatetime
set@datefrom=DATEADD(day,-((DATEPART(dw,GETDATE())+@@DATEFIRST)%7)-6,
DATEADD(day,DATEDIFF(day,0,GETDATE()),0))
set@dateto=DATEADD(day,-(DATEPART(dw,GETDATE())+@@DATEFIRST)%7,
DATEADD(day,DATEDIFF(day,0,GETDATE()),0))
Select@datefrom
select@dateto
http://www.c-sharpcorner.com/code/3722/get-last-week-date-in-sql.aspx
Vinay Singh10y ago
Hi check the query
select * from coursedetails where coursedate between cast(GETDATE() as date) )and CAST(DATEADD(d,1,GETDATE()) as date)
Midhun Tp10y ago
Hi,
Try below query -
select * from coursedetails where cast(coursedate as date) in (cast(GETDATE() as date),CAST((DATEADD(d,1,getdate())) as date))

Please try to accept the answer if it is helpful for you, because that may help someone else with same problem and also gives people like us something to cheer about :)