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位

ITPub博客

oracle timestamp的最大值

最新文章