By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,990 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,990 IT Pros & Developers. It's quick & easy.

How to find fourth Saturday of month?

P: 2
Hi Guys,

Please let me know that how to find fourth Saturday of month.
Jan 16 '14 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,364
Start at the first day of the month, add 28 days and subtract the week day number. Assuming of course your nls_territory default uses 1 for Sunday, which is the case in America.
Jan 16 '14 #2

P: 2
I need American format, please help me.
Jan 17 '14 #3

Rabbit
Expert Mod 10K+
P: 12,364
Then you can use the algorithm I already laid out in post #2. If you are having trouble implementing it, you need to show us the code you tried along with a descriptiont of any errors you get.
Jan 17 '14 #4

Expert 100+
P: 1,035
"I need American format, please help me......."
There's a complete internet page available on 'American (date) format'
http://en.wikipedia.org/wiki/Date_an..._United_States
Jan 18 '14 #5

Post your reply

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