Re: Find free appointments faster
> my very first idea would be to store the end of the interval by subtracting a smaller unit from the endtime
Very first ideas are often not so good as later ideas. A feature of the method is to remove any need to subtract token units.
SQL is not well designed for managing time data. If you're working more than occasionally with time, as you are, it's advisable to read about sql and time, the classic source is
https://www2.cs.arizona.edu/~rts/tdbbook.pdf
Subject
Views
Written By
Posted
3692
November 08, 2017 12:32AM
723
November 08, 2017 12:48AM
757
November 08, 2017 04:57AM
755
November 08, 2017 10:43PM
745
November 08, 2017 11:31PM
671
November 09, 2017 09:27AM
Re: Find free appointments faster
691
November 14, 2017 10:19AM
674
November 14, 2017 09:31AM
758
November 08, 2017 11:22PM
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.