Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Weekends and Holidays
How can I exlcude any weekends and/or holidays in a report? I am trying to calculate how long it takes to ship an item from the time the order was taken. We currently just subtract the date entered from the date shipped but this does not take into account any weekends or...- hendoo49
- Thread
- Replies: 1
- Forum: Oracle: Reports
-
A CIO looking to commiserate
Ghost,<br> I have an experience of working with an outside source for getting our business into ecommerce. This company (we'll call them ABC) was very technical and knew their stuff. We are very happy with the outcome but, yes there is a but, (there...- hendoo49
- Post #11
- Forum: Tech Industry Trends
-
Looking for a way to update the ever changing area codes
I am looking for the information to update our outdated aarea and postal codes for U.S. and Canada. I found several sources on the web which offer their services or provide their own software to assist in this task but I've yet to find one that easily works with Oracle. What I am looking for...- hendoo49
- Thread
- Replies: 0
- Forum: Oracle: Enterprise Developer Suite
-
How can I calculate the time bewtween two dates??
Thanks Kalyan. Since time was an issue I already found a work around. We converted the end result (2.124678) into a day and hour format. Not the best answer but it worked. I think in the future I may want to use your solution and since it is a long statement I may create it as a function and... -
How can I calculate the time bewtween two dates??
Using PL/SQL in Oracle I would like to find out the time between two dates. i.e. Given 20-July-1999 10:00 to 22-July-1999 13:00 the time between would be 2 days and 3 hours. The way I am doing it I get a decimal returned. For the example above I would get something back like 2.12467893...
