Iwinter
Iwinter

 -

  • (12)
  •    1 8.2. (3)
  •    1 7.7. (1)
  • (10)
  • (9)
  • (5)
  • (2)
  • (1)
  • (1)

 -

 -

 - e-mail

 

 -

Iwinter

 -

LiveInternet.ru:
: 28.04.2008
:
:
: 228

:


( Oracle)

, 20 2009 . 10:09 +

"" Date. ("" ). /, , . . .

DATE Oracle . , 7 .: 1. 2. 3. 4. 5. 6. 7. . .

- TO_DATE( [,]), TO_CHAR( [, ]) - , .  , /.

 ,    , , , , , . , -, , . ,   / / ( ADD_MONTHS() )/ , (/ / ), ., :

SELECT SYSDATE+7 FROM DUAL --

SELECT TO_CHAR(SYSDATE, 'DD.MM.YYYY HH:MI:SS'), TO_CHAR(SYSDATE + (20/1440), 'DD.MM.YYYY HH:MI:SS')

-- 20 ( 1440 .). 

  ;)  . , " Oracle SQL" . . !

 

: 
:  

— — : [1] []
   , 29 2009 . 14:13 ()

select to_oradate(131465502)
from dual
30.01.06

select to_oradate(131465502 + 1)
from dual
31.01.06

select to_oradate(131465502 + 2)
from dual

2
select to_oradate(131465502 ) + 2 --
from dual
)))
        |    
Iwinter   , 01 2009 . 11:24 ()
, , to_oradate. , oracle? -, - ...
   
   , 16 2009 . 13:02 ()
Oracle SQL Developer 1.2.0

(DATETIME INTEGER)
RETURN DATE AS MM INTEGER;
YY INTEGER;
TMP INTEGER;
BEGIN YY := DATETIME / 65536; --131465502/65536 = 2006
TMP := MOD(DATETIME,65536); 288
MM := TMP / 256; 7.8 1
TMP := MOD(TMP,256);
RETURN TO_DATE(TO_CHAR(TMP)||'.'||TO_CHAR(MM)||'.'||TO_CHAR(YY),'DD.MM.YYYY');
END;
131465729
        |    
   , 23 2012 . 07:33 ()
select to_date('01.01.2012','dd.mm.yyyy')+interval '1' minute+interval '1' hour+interval '1' second from dual - ,
        |    
— — : [1] []
 

:
: 

: ( )

:

  URL