Oracle: date - date
Karel Zak
zakkr na zf.jcu.cz
Pondělí Listopad 10 11:38:31 CET 2003
On Mon, Nov 10, 2003 at 10:55:33AM +0100, Pavel Stehule wrote:
> On Mon, 10 Nov 2003, Jan Kasprzak wrote:
>
> > Ladislav Pavlič wrote:
> > : c := (a-b) DAY TO SECOND;
> >
> > Jo, tohle funguje (stejne jako pretypovani na timestamp).
> > Ja jsem se ale ptal nikoliv jak to udelat (to uz mam), ale jestli
> > nekdo netusite, co mohlo vest Oracle k tomu, aby vyraz typu date - date
> > nebyl definovany, zatimco timestamp - timestamp ano?
>
> ANSI SQL?
> Pavel
Zkousel jsem to hledat a naopak jsem nasel v SQL92 (4.5.3 Operations
involving datetimes and intervals):
Datetime - Datetime = Interval
kde <datetime> je:
There are three classes of datetime data types defined within this
International Standard:
- DATE - contains the <datetime field>s YEAR, MONTH, and DAY;
- TIME - contains the <datetime field>s HOUR, MINUTE, and
SECOND; and
- TIMESTAMP - contains the <datetime field>s YEAR, MONTH, DAY,
HOUR, MINUTE, and SECOND.
Takze s DATE, TIME a TIMESTAMP by to melo jit. I kdyz je mozne, ze
nekde o tisic radek dal je v tom standardu poznamka, ze to jit nema :-)
Karel
--
Karel Zak <zakkr na zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
Další informace o konferenci Test