Guest_imported
New member
- Jan 1, 1970
- 0
how do you display the day of the week and how can i limit a query to the days of the week and not the weekend 
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL subqueries + date formats
- Thread starter Guest_imported
- Start date
- Status
tlbroadbent
MIS
Use the Weekday or Datepart function.
Select * From Table
Where Weekday(DateCol) Between 2 And 6
This assumes that Sunday is the first day of the week and Saturday is the last or 7th day. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Question
- Locked
- Question
