Re: Design of a work time calender
Posted by: Zero-G. _
Date: December 30, 2014 08:29AM

Hey!

Thanks for your answer. - There is a main additional question, I don't know how to solve:

When a customer is working for example every Monday. How should I store this? - I can't store every Monday for a year. - Would not make sense...

As you said, I should be Aware of the query. My thought was:
creating 2 additional fields:
Intervall
EndDate (NullAble)

When there is a Null, then there is no end date. - With Intervall, I could set for example 7 (every 7 days)

BUT - How should I get the data with the Select ?

THX a lot - Happy new Year!

Options: ReplyQuote


Subject
Written By
Posted
December 29, 2014 03:46AM
Re: Design of a work time calender
December 30, 2014 08:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.