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