Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Oracle Date Difference Excluding Weekends
Joined: Feb 26, 2003
Apr 12, 2005 03:25:00
I want to get the difference between two dates which will not include weekends, saturdays and sundays are not be included in the count.
Can this be solved by means of ann oracle query? or I need to create a function for this in oracle? If so,
Any idea? or maybe an algorithm for such?
Joined: May 26, 2003
Apr 12, 2005 18:20:00
You are going to need to write a function for this. Scroll down on this
list of Oracle date functions
to the "date calculations" section. They have some examples.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Joined: Oct 11, 2000
Apr 12, 2005 23:50:00
I searched the archives of the "comp.databases.oracle.*" newsgroups and found the following (which may be of help):
Also found this (at the "Ask Tom" Web site):
[ April 13, 2005: Message edited by: Avi Abrami ]
It is sorta covered in the
JavaRanch Style Guide
subject: Oracle Date Difference Excluding Weekends
deadline for SCEA is very close what i should do ?
Orion vs. Oracle
What do you do on Weekends...
Find difference between two dates by elimating weekends
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013