Oracle PL/SQL/Date Timezone/numtodsinterval
Содержание
- 1 current_timestamp + numtodsinterval( 2, "hour" )
- 2 current_timestamp + numtoyminterval( 3, "month" ) current_timestamp
- 3 numtodsinterval(150000, "SECOND")
- 4 numtodsinterval(15000, "MINUTE")
- 5 numtodsinterval(1500, "HOUR")
- 6 numtodsinterval(150, "DAY")
- 7 NUMTODSINTERVAL(3.25, "HOUR")
- 8 NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit
current_timestamp + numtodsinterval( 2, "hour" )
<source lang="sql">
SQL> SQL> SQL> column current_timestamp format a38 SQL> select current_timestamp from dual; CURRENT_TIMESTAMP
16-JUN-08 04.27.20.203000 PM -08:00 1 row selected. SQL> select current_timestamp + numtodsinterval( 2, "hour" ) current_timestamp from dual; CURRENT_TIMESTAMP
16-JUN-08 06.27.20.284000000 PM -08:00 1 row selected. SQL> SQL> --
</source>
current_timestamp + numtoyminterval( 3, "month" ) current_timestamp
<source lang="sql">
SQL> SQL> SQL> select current_timestamp from dual; CURRENT_TIMESTAMP
16-JUN-08 04.27.20.414000 PM -08:00 1 row selected. SQL> SQL> select current_timestamp + numtoyminterval( 3, "month" ) current_timestamp from dual; CURRENT_TIMESTAMP
16-SEP-08 04.27.20.514000000 PM -08:00 1 row selected. SQL> SQL> --
</source>
numtodsinterval(150000, "SECOND")
<source lang="sql">
SQL> select numtodsinterval(150000, "SECOND") from dual; NUMTODSINTERVAL(150000,"SECOND")
+000000001 17:40:00.000000000 SQL>
</source>
numtodsinterval(15000, "MINUTE")
<source lang="sql">
SQL> select numtodsinterval(15000, "MINUTE") from dual; NUMTODSINTERVAL(15000,"MINUTE")
+000000010 10:00:00.000000000 SQL>
</source>
numtodsinterval(1500, "HOUR")
<source lang="sql">
SQL> select numtodsinterval(1500, "HOUR") from dual; NUMTODSINTERVAL(1500,"HOUR")
+000000062 12:00:00.000000000 SQL>
</source>
numtodsinterval(150, "DAY")
<source lang="sql">
SQL> SQL> select numtodsinterval(150, "DAY") from dual; NUMTODSINTERVAL(150,"DAY")
+000000150 00:00:00.000000000 SQL>
</source>
NUMTODSINTERVAL(3.25, "HOUR")
<source lang="sql">
SQL> SQL> select NUMTODSINTERVAL(3.25, "HOUR") from dual; NUMTODSINTERVAL(3.25,"HOUR")
+000000000 03:15:00.000000000 SQL>
</source>
NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit
<source lang="sql">
SQL> SQL> --NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit. SQL> SQL> SELECT NUMTODSINTERVAL(1.5, "DAY") FROM dual; NUMTODSINTERVAL(1.5,"DAY")
+000000001 12:00:00.000000000 SQL>
</source>