 | |
#1
 
| |||
| |||
|
Interval data... -
02-20-2006
, 09:43 AM
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
Volker Hetzer <volker.hetzer (AT) ieee (DOT) 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 |
Pity. Seems I have to work with date pairs instead.
Lots of Greetings!
Volker
#4
| |||
| |||
|
|
ianal Vista schrieb: Volker Hetzer <volker.hetzer (AT) ieee (DOT) 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 |
My bed is 2 m long, where is the head and where is the foot?
This the same question.
Regards
Michel Cadot
#5
| |||
| |||
|
|
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 |
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
#6
| |||
| |||
|
|
Volker Hetzer wrote: 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. where date between ? Exactly. |
Lots of Greetings!
Volker
#7
| |||
| |||
|
|
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. I was hoping that sql follows ISO8601 with regards to time intervals. |
interval between two numbers, like [0,5] for instance.
Lots of Greetings!
Volker
#8
| |||
| |||
|
|
Michel Cadot schrieb: 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. I was hoping that sql follows ISO8601 with regards to time intervals. The iso standard defines an interval like mathematicians define the interval between two numbers, like [0,5] for instance. Lots of Greetings! Volker |
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.