Derby
  1. Derby
  2. DERBY-4625

TIMESTAMP function doesn't accept nanoseconds

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0
    • Fix Version/s: 10.5.3.2, 10.6.2.4, 10.7.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      The TIMESTAMP function fails if the string argument specifies the number of nanoseconds. It works if the argument is limited to microsecond resolution.

      ij> values timestamp('2010-04-21 12:00:00.123456');
      1
      --------------------------
      2010-04-21 12:00:00.123456

      1 row selected
      ij> values timestamp('2010-04-21 12:00:00.123456789');
      ERROR 22008: '2010-04-21 12:00:00.123456789' is an invalid argument to the timestamp function.

      Since Derby (and JDBC) supports nanosecond resolution, the TIMESTAMP function should also support it.

      1. derby-4625-1.diff
        2 kB
        Nirmal Fernando
      2. derby_4625-2.diff
        4 kB
        Nirmal Fernando

        Issue Links

          Activity

            People

            • Assignee:
              Nirmal Fernando
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development