Hello:
Maybe somebody on the list can give me a hand with this. I
have:
id serial,
start time,
duration time
(That is, ids have an start time and a duration).
I want to know which ids are current, ie, which satisfy
start<=now<=start+duration.
The problem is that start+duration is an interval, and I
can't find the way to cast now to interval or interval to time or
tinterval in order to make the comparison.
Any ideas?
Thanks in advance.
Fernando P. Schapachnik
fernando(at)schapachnik(dot)com(dot)ar