Hi,
My input has two timestamps,I need to calculate the number of days between these two timestamps excluding weekends.
Any help would be appreciated.
My source is Orcale.
ThankYou,
Sudheer.
calculate number of days excluding weekends
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can use Oracle functions or you can use DataStage.
If you use DataStage you will need either a (parallel) routine or a calendar table to determine which days are weekends. This is particularly true if your requirement extends the definition of "weekend" to include "holiday".
If you use DataStage you will need either a (parallel) routine or a calendar table to determine which days are weekends. This is particularly true if your requirement extends the definition of "weekend" to include "holiday".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
I was wondering how can a 7.5.1a be parallel?
It certainly can't run those kind of jobs!
Most simple way is to use a sql join to calculate it from the calendar table
IHTH,
I was wondering how can a 7.5.1a be parallel?
It certainly can't run those kind of jobs!
Most simple way is to use a sql join to calculate it from the calendar table
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org