SQL> insert into t_timestamp values(to_timestamp('2013-02-28'||'23:59:59.9999999991'));

insert into t_timestamp values(to_timestamp('2013-02-28'||'23:59:59.9999999991'))

ORA-01830: date format picture ends before converting entire input string

SQL> insert into t_timestamp values(to_timestamp('2013-02-28'||'23:59:59.999999999'));

1 row inserted

小結：999999999為最大值，共計9位

oracle timestamp的最大值

相關文章