RE: How to calculate the working hours?

2003-03-19 Thread Jacques Kilchoer
Title: RE: How to calculate the working hours? (re-sending because my e-mail from yesterday never made it to the list) see answer below > -Original Message- > From: Andrea Oracle [mailto:[EMAIL PROTECTED]] > > We have open Time for every order, ef: &g

Re: How to calculate the working hours?

2003-03-19 Thread Igor Neyman
Title: RE: How to calculate the working hours? What about holydays?   Igor Neyman, OCP DBA[EMAIL PROTECTED]      - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 18, 2003 9:53 PM Subject: RE: How to

RE: How to calculate the working hours?

2003-03-18 Thread Jacques Kilchoer
Title: RE: How to calculate the working hours? see answer below > -Original Message- > From: Andrea Oracle [mailto:[EMAIL PROTECTED]] > > We have open Time for every order, ef: > > Open Time > -- > 03/12/03 11:08:07 > > How to ca

RE: How to calculate the working hours?

2003-03-18 Thread BALA,PRAKASH (HP-USA,ex1)
Andrea, Will the following work? table business_hours( system_date date, business_day_flag varchar2(1), -- Y/N to indicate a holiday start_hour varchar2(10), end_hour varchar2(10)) -- If Dec 31st is a working day but half-day, this column can help you with that This table will have an entry for