Précision par défaut du timestamp

C'est pourtant bien ce qui a été fait.

Citation:

where fractional_seconds_precision optionally specifies the number of digits Oracle stores in the fractional part of the SECOND datetime field. When you create a column of this data type, the value can be a number in the range 0 to 9. The default is 6

Voici un exemple

Code:

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
33
34
35
36
 
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 
Connected as mni@parvatI
 
SQL> 
SQL> create table tm(
  2   a     timestamp,
  3   b     timestamp(9),
  4   c     date
  5  )
  6  /
Table created
SQL> desc tm
Name Type         Nullable Default Comments 
---- ------------ -------- ------- -------- 
A    TIMESTAMP(6) Y                         
B    TIMESTAMP(9) Y                         
C    DATE         Y                         
SQL> insert into tm values (systimestamp, systimestamp, sysdate)
  2  /
1 row inserted
SQL> commit
  2  /
Commit complete
SQL> alter table tm modify c timestamp
  2  /
Table altered
 
SQL> desc tm
Name Type         Nullable Default Comments 
---- ------------ -------- ------- -------- 
A    TIMESTAMP(6) Y                         
B    TIMESTAMP(9) Y                         
C    TIMESTAMP(6) Y                         
 
SQL>