Using query get date for today date and tomorrow date

Question

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

ketan borsdiya · Answer

Hi Narasiman Use below Query Declare @date as datetime='2016-08-29' select * from Coursedetails where DATEDIFF(DAYCoursedate@date)=0 Union all select * from Coursedetails where DATEDIFF(DAYCoursedate@date-1)=0

Bikesh Srivastava · Answer

Hi try this.. declare@datefromdatetime declare@datetodatetime set @datefrom=DATEADD(day-((DATEPART(dwGETDATE())+@@DATEFIRST)%7)-6 DATEADD(dayDATEDIFF(day0GETDATE())0)) set @dateto=DATEADD(day-(DATEPART(dwGETDATE())+@@DATEFIRST)%7 DATEADD(dayDATEDIFF(day0GETDATE())0)) Select@datefrom select@dateto http://www.c-sharpcorner.com/code/3722/get-last-week-date-in-sql.aspx

Vinay Singh · Answer

Hi check the query select * from coursedetails where coursedate between cast( GETDATE() as date) )and CAST(DATEADD(d1 GETDATE() ) as date)

Midhun T P · Answer

Hi Try below query - select * from coursedetails where cast(coursedate as date) in (cast(GETDATE() as date)CAST((DATEADD(d1getdate())) 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 :)