Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

querying a date range in MS SQL

Status
Not open for further replies.

notstock78

Technical User
Jul 13, 2005
9
US
I am trying to find the proper syntax for querying every thing from a specific date range using MS SQL. The table is SE_DATA and the field is SEDATE.
 
Select <whatever> from SE_DATA where SEDATE >= <startdate> and SEDATE <= <enddate>

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright
 
Thank you, it works great. I am just starting learn SQL and I have been struggling with some of the syntax.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top