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
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
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
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