Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Which dates occured on a Sunday?

    how can i write a query so it picks up all the dates that occured on a Sunday?

    so i have a date field with over 300 records, i need to highlight which of those records (dates) are on a sunday

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    WHERE WEEKDAY(date) = 1
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2007
    Posts
    127
    Quote Originally Posted by r937
    WHERE WEEKDAY(date) = 1
    thanks for the reply...

    if the my date fields is called "AdmissionDate", how do i use the above statement in a query?

  4. #4
    Join Date
    Oct 2007
    Posts
    127
    thanks mate... i've worked it out

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •