db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4625) TIMESTAMP function doesn't accept nanoseconds
Date Wed, 21 Apr 2010 10:58:51 GMT
TIMESTAMP function doesn't accept nanoseconds

                 Key: DERBY-4625
                 URL: https://issues.apache.org/jira/browse/DERBY-4625
             Project: Derby
          Issue Type: Bug
    Affects Versions:
            Reporter: Knut Anders Hatlen
            Priority: Minor

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

ij> values timestamp('2010-04-21 12:00:00.123456');
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.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message