Click here to Skip to main content
15,905,148 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
select date from Ordersdate

not to display current date and next day date remaining dates needs to display.

Thanks
Vinoth

What I have tried:

select date from Ordersdate 

not to display current date and next day date remaining dates needs to display.

Thanks
Vinoth
Posted

1 solution

Add an SQL WHERE Clause[^]
Provided you have stored your dates in DATE, DATETIME, or DATETIME2 in your DB, SQL can cope with date comparisons just as it can cope with numeric ones. You may also find the SQL Server DATEADD() Function[^] useful in this.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900