| urgent help [message #2940] |
Fri, 23 August 2002 10:28  |
Gopi
Messages: 8
Registered: July 2002
|
Junior Member |
|
|
I need to find the difference between two dates. But it should not consider weekends.
for example, if the start_date is on a friday and the end_date is on tuesday, the difference between the two dates should be only 1. It should not consider the weekends. I would really appreciate if anyone can help me on this.
|
|
|
|
| Re: urgent help [message #2942 is a reply to message #2940] |
Fri, 23 August 2002 11:13  |
lkrylov
Messages: 3
Registered: August 2002
|
Junior Member |
|
|
|
I don't know if it's the most efficient but if I had to do this I would create a separate column that recorded what day of the week (to_char({your date field}, 'd'))it was and then do a decode for the calculation. It's probably more work but if your stuck it's a way to get the answer. Maybe a more experienced person will have a better answer.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
