Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-234

Documentation of DateTime types is incomplete

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: