473,385 Members | 1,908 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

how to get dates of all saturdays in 2011

bajajv
152 100+
Hi,
I need to write an SQL query to compare all the weekends in 2011.
I have a table with orders and the dates for delivery.
I just want to get a list of all orders on weekends in 2011.
How can I do that?
Just need a hint for a logic or some function which can give whether it is saturday or not.

Thanks.
Oct 29 '11 #1
1 2388
rski
700 Expert 512MB
I'm not sure if I understand you problem, but to check if a date is Saturday you can use to_char function witch 'DAY' format
See here http://www.techonthenet.com/oracle/f...ns/to_char.php
Nov 5 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Maarten | last post by:
Hi, i need to fill a dropdownlist in a frame with only saturdays. The code must be like: <select class="fld" size="1" name="arrivaldate"> <option value="17/01/2004">17/01/2004</option>...
2
by: MLH | last post by:
With a table of holidays and A97's date fn's - how best to count weekends and holidays between two dates? My holiday table has 4 fields. I will be adding records to it each year as info becomes...
18
by: mlcampeau | last post by:
I have a lengthy query that I am now trying to filter. The query calculates an employee's Anniversary Date in which they are eligible for the next level of Annual Vacation. (i.e. For 1-6 years of...
8
code green
by: code green | last post by:
I need to generate the date for the latest Friday and the Saturday previous to this ie 7 days. I am generating reports for the periods Yesterday, Month to date and Sat-Fri so I create the dates in...
2
by: sivasweety | last post by:
' TD1 to TD18 to get date values one by one. Dim Fd1, Fd2, Fd3, Fd4, Fd5, Fd6, Fd7, Fd8, Fd9, Fd10, Fd11, Fd12, Fd13, Fd14, Fd15, Fd16, Fd17, Fd18 As Date Dim TD1, TD2, TD3, TD4, TD5, TD6,...
2
by: tech607 | last post by:
HI , Below xml contains a list (CommitmentP_L). Using xpath I want to retrieve COMMIT_PKG_ID from the list item having latest ASSIGN_DATE. For example below xml contains 2 list item, the commit...
1
by: Emaline | last post by:
I am responsible for tracking training hours each year for a number of employees. I have just developed a database that includes both the fields "date" (of training) and "hours" I want to sum the...
1
by: Selun | last post by:
hi, and thanx in advance. Im trying to update a table which has Dates using UPDATE Publications.Issue SET IssueDate=04/01/2011 where id=48 and i get 4/1/1900.
3
by: Coolboy55 | last post by:
Hi everyone, I'm having some trouble with a query. I have a history table where one of the fields is a date stamp. My query takes a date from the user, and I want the query to return all records...
3
by: mikeyeli | last post by:
Hey guys!, i have to do the following: Suppose i have the following data: ID ACTIVITY DATE 1 gardening 01/01/2011 2 cooking 02/01/2011 1 gardening ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.