1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
SQL> create table scott.test_date (col1 date);
Table created.
SQL> insert into scott.test_date (COL1) values (to_date('02/04/2007 15:59:05', 'DD/MM/YYYY HH24:MI:SS'));
1 row created.
SQL> insert into scott.test_date (COL1) values (to_date('02/04/2007 16:00:07', 'DD/MM/YYYY HH24:MI:SS'));
1 row created.
SQL> commit;
Commit complete.
SQL> alter session set nls_date_format='DD/MM/YYYY HH24:MI:SS';
Session altered.
SQL> select col1, dump(col1) from scott.test_date;
COL1
-------------------
DUMP(COL1)
--------------------------------------------------------------------------------
02/04/2007 15:59:05
Typ=12 Len=7: 120,107,4,2,16,60,6
02/04/2007 16:00:07
Typ=12 Len=7: 120,107,4,2,17,1,8 |
Partager