Derby
  1. Derby
  2. DERBY-234

Documentation of DateTime types is incomplete

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.3.1.4
    • Component/s: Documentation
    • Labels:
      None

      Description

      The documentation for datatypes DATE, TIME, and TIMESTAMP is incomplete. The documentation says that DATE, TIME, and TIMESTAMP accept any values accepted by the java.sql.Date, java.sql.Time, and java.sql.Timestamp classes respectively. Derby accepts a number of string formats:

      DATE:
      yyyy-mm-dd
      mm/dd/yyyy
      dd.mm.yyyy

      TIME:
      hh:mm[:ss]
      hh.mm[.ss]
      hh[:mm]

      {AM | PM}

      TIMESTAMP:
      yyyy-mm-dd-hh[.mm[.ss[.nnnnnn]]]
      yyyy-mm-dd hh[:mm[:ss[.nnnnnn]]]

      The year must always have 4 digits. Months, days, and hours may have one or two digits. Minutes and seconds, if present, must have two digits. Nanoseconds, if present may have 1 to 6 digits.

      Derby also accepts strings in the locale specific datetime format, using the locale of the database server. If there is an ambiguity the built in formats above take precedence.

      1. mmss_required.diff
        2 kB
        Bryan Pendleton
      2. rrefsqlj27620.html
        7 kB
        Bryan Pendleton
      3. derby234.diff
        8 kB
        Jeff Levitt

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 41936 ] Default workflow, editable Closed status [ 12797577 ]
          Dyre Tjeldvoll made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Bryan Pendleton made changes -
          Derby Info [Patch Available]
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Bryan Pendleton made changes -
          Derby Info [Patch Available]
          Bryan Pendleton made changes -
          Attachment mmss_required.diff [ 12348113 ]
          Attachment rrefsqlj27620.html [ 12348114 ]
          Bryan Pendleton made changes -
          Assignee Bryan Pendleton [ bryanpendleton ]
          Andrew McIntyre made changes -
          Link This issue relates to DERBY-2203 [ DERBY-2203 ]
          Bryan Pendleton made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Jeff Levitt made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Jean T. Anderson made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Jeff Levitt made changes -
          Field Original Value New Value
          Attachment derby234.diff [ 19847 ]
          Jack Klebanoff created issue -

            People

            • Assignee:
              Bryan Pendleton
              Reporter:
              Jack Klebanoff
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development