Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> How to calculate the working hours?
Hi,
I haven't got too many response to my working hour question, probably because I sent it out late Friday night. Let me send that question again, really appreciate your help!
Open Time
How to calculate the working hours (8am - 5pm, no weekends) that a file remain open until now? (Sysdate - Open_Time) returns all the hours including weekend and <8am, >5pm hours. We only like to know the WORKING hours.
Thank you so much!
Andrea
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 18 2003 - 09:49:11 CST