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. DERBY-5596.diff
        2 kB
        Kim Haase
      2. rrefsqlj27620.html
        4 kB
        Kim Haase

        Activity

        Hide
        Kim Haase added a comment -

        Since we keep getting questions about this, now seems a good time to fix it.

        I'm attaching DERBY-5596.diff and rrefsqlj27620.html, with modifications to the "TIMESTAMP data type" topic. Please let me know if changes are needed.

        I do have one question. Below the syntax it says, "The first of the two formats above is the java.sql.Timestamp format." One naturally wonders, what is the second format? Do we have an answer?

        Show
        Kim Haase added a comment - Since we keep getting questions about this, now seems a good time to fix it. I'm attaching DERBY-5596 .diff and rrefsqlj27620.html, with modifications to the "TIMESTAMP data type" topic. Please let me know if changes are needed. I do have one question. Below the syntax it says, "The first of the two formats above is the java.sql.Timestamp format." One naturally wonders, what is the second format? Do we have an answer?
        Hide
        Rick Hillegas added a comment -

        Hi Kim,

        Thanks for making these changes. I don't know a handy name for the other format. Documentation for the two formats goes back to 10.1. The formats don't appear in the 10.0 reference guide. I think it's ok for the other format to not have a handy name. +1 to these changes.

        Show
        Rick Hillegas added a comment - Hi Kim, Thanks for making these changes. I don't know a handy name for the other format. Documentation for the two formats goes back to 10.1. The formats don't appear in the 10.0 reference guide. I think it's ok for the other format to not have a handy name. +1 to these changes.
        Hide
        Kim Haase added a comment -

        Thanks, Rick! If no one's asked the question before, there's no need to answer it.

        Committed patch DERBY-5596.diff to documentation trunk at revision 1310489.

        Show
        Kim Haase added a comment - Thanks, Rick! If no one's asked the question before, there's no need to answer it. Committed patch DERBY-5596 .diff to documentation trunk at revision 1310489.
        Hide
        Kim Haase added a comment -

        Fix has appeared in Latest Alpha Manuals.

        Show
        Kim Haase added a comment - Fix has appeared in Latest Alpha Manuals.

          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