Oracle PL/SQL/Date Timezone/TO TIMESTAMP — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
(нет различий)
|
Текущая версия на 10:01, 26 мая 2010
Содержание
- 1 to_timestamp("2003/DEC/13 10:13:18", "YYYY/MON/DD HH:MI:SS")
- 2 to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH12:MI:SS")
- 3 to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH24:MI:SS")
- 4 to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH:MI:SS")
- 5 TO_TIMESTAMP(x): Converts the string x to a TIMESTAMP
to_timestamp("2003/DEC/13 10:13:18", "YYYY/MON/DD HH:MI:SS")
SQL> select to_timestamp("2003/DEC/13 10:13:18", "YYYY/MON/DD HH:MI:SS") from dual;
TO_TIMESTAMP("2003/DEC/1310:13:18","YYYY/MON/DDHH:MI:SS")
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM
SQL>
to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH12:MI:SS")
SQL> select to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH12:MI:SS") from dual;
TO_TIMESTAMP("2003/DEC/1310:13:18","YYYY/MONTH/DDHH12:MI:SS")
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM
SQL>
to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH24:MI:SS")
SQL> select to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH24:MI:SS") from dual;
TO_TIMESTAMP("2003/DEC/1310:13:18","YYYY/MONTH/DDHH24:MI:SS")
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM
SQL>
SQL>
to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH:MI:SS")
SQL> select to_timestamp("2003/DEC/13 10:13:18", "YYYY/MONTH/DD HH:MI:SS") from dual;
TO_TIMESTAMP("2003/DEC/1310:13:18","YYYY/MONTH/DDHH:MI:SS")
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM
SQL>
TO_TIMESTAMP(x): Converts the string x to a TIMESTAMP
SQL>
SQL> --TO_TIMESTAMP(x): Converts the string x to a TIMESTAMP.
SQL>
SQL> select to_timestamp("2003/12/13 10:13:18", "YYYY/MM/DD HH:MI:SS") from dual;
TO_TIMESTAMP("2003/12/1310:13:18","YYYY/MM/DDHH:MI:SS")
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM
SQL>