[DERBY-5596] TIMESTAMP doc gives wrong precision limitation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.8.2.2
• Fix Version/s: 10.9.1.0
• Component/s: Documentation
• Assignee: Camilla Haase
• Reporter: Dag H. Wanvik
• Created: 02/Feb/12 03:36
• Updated: 11/Apr/12 20:36
• Resolved: 06/Apr/12 17:34

Description

Derby accepts nanosecond fractions. e,g.

create table t(i timestamp);
insert into t values TIMESTAMP('1962-09-23 03:23:34.123456789');

but the refman doc states:

> Derby supports the following formats for TIMESTAMP:
>
> yyyy-mm-dd hh:mm:ss[.nnnnnn]
> yyyy-mm-dd-hh.mm.ss[.nnnnnn]
>
> The first of the two formats above is the java.sql.Timestamp format.
>
>The year must always have four digits. Months, days, and hours may have one or two digits. Minutes and seconds must have two digits.
>Nanoseconds, if present, may have between one and six digits.

Nine digits are accepted, not six:

select * from t;
I
-----------------------------
1962-09-23 03:23:34.123456789