Re: Interval data...

"Volker Hetzer" <volker.hetzer_at_ieee.org> a écrit dans le message de news: dtd03t$o39$1_at_nntp.fujitsu-siemens.com...
| 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.

|

Interval is a length it does not have a begin and an end. My bed is 2 m long, where is the head and where is the foot? This the same question.

Regards
Michel Cadot Received on Mon Feb 20 2006 - 12:17:13 CST