ianal Vista schrieb:
> Volker Hetzer <volker.hetzer_at_ieee.org> wrote in news:dtco2j$scn$1
> @nntp.fujitsu-siemens.com:
>
>> Hi!
>> Given an interval, how can I identify the first and last dates/times
>> of it?
>> I had a look at the doc but there isn't much there for this.
>>
>> Lots of Greetings1
>> Volker
>>
>
> Try MIN() and MAX()
Figured out the problem. Oracle intervals aren't like
'from july the 3th to october 23th, 2006' but only '3 months, 5 days'.
Pity. Seems I have to work with date pairs instead.
Lots of Greetings!
Volker
Received on Mon Feb 20 2006 - 12:00:28 CST
