Derby
  1. Derby
  2. DERBY-5596

TIMESTAMP doc gives wrong precision limitation

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.2.2
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      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

      1. rrefsqlj27620.html
        4 kB
        Kim Haase
      2. DERBY-5596.diff
        2 kB
        Kim Haase

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Kim Haase
            Reporter:
            Dag H. Wanvik
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development