4
Answers

Using query get date for today date and tomorrow date

narasiman rao

narasiman rao

8y
281
1
  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
 

Answers (4)