Advertisement

05.01.2006 at 09:54AM PDT, ID: 21833540
[x]
Attachment Details

SELECT data by day of week

Asked by AshleyBryant in MS SQL Server

Tags: week, day, select, data

Assuming that I have a table with a date value (mm/dd/yyyy) in one of the fields, how can I select records from that table based on the day of the week?  So, if I wanted to get all records that occured on a Tuesday for example.Start Free Trial
[+][-]05.01.2006 at 09:56AM PDT, ID: 16578549

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: week, day, select, data
Sign Up Now!
Solution Provided By: jimhorn
Participating Experts: 1
Solution Grade: A
 
 
[+][-]05.01.2006 at 09:59AM PDT, ID: 16578571

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32