Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Interval data...

Re: Interval data...

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 20 Feb 2006 19:17:13 +0100
Message-ID: <43fa07a9$0$4781$636a55ce@news.free.fr>

"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.

|

| Lots of Greetings!
| Volker

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US