Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Answers
Using query get date for today date and tomorrow date
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
narasiman rao
8y
280
1
Reply
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
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
how to retrieve file name to be stored in variable
How to handle datareader for TCP socket communication