db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4611) Add new datatypes: TIME WITH TIMEZONE and TIMESTAMP WITH TIMEZONE
Date Wed, 15 Dec 2010 13:31:10 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12971680#action_12971680

Rick Hillegas commented on DERBY-4611:

Thanks for expressing interest in this issue, Greg. This feature may be considered for the
next feature release, but no-one has indicated that they are working on it yet: http://wiki.apache.org/db-derby/DerbyTenEightOneRelease#A10.8.1_Work

> -----------------------------------------------------------------
>                 Key: DERBY-4611
>                 URL: https://issues.apache.org/jira/browse/DERBY-4611
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Rick Hillegas
> The SQL Standard defines two timezone-stamped datatypes: TIME WITH TIMEZONE and TIMESTAMP
WITH TIMEZONE. Relevant sections in part 2 of the Standard include 4.6 (Datetimes and intervals),
6.1 (<data type>), 6.12 (<cast specification>), and 8.2 (<comparison predicate>).
> I think that we could implement these two datatypes today. Note that there is a general
cleanup of the Java datetime classes underway in JSR 310 ( https://jsr-310.dev.java net/ ),
which is supposed to be delivered in Java 7. It's possible that the next rev of JDBC will
provide better support for these datatypes. However, there is currently no JSR covering the
next JDBC increment. 
> For the moment, the existing JDBC TIME and TIMESTAMP types would have to be overloaded
to cover the new datatypes. Disambiguating the WITH TIMEZONE variants might have to be accomplished
by parsing the type names returned by ResultSetMetaData.getColumnTypeName() and DatabaseMetaData.getColumns().TYPE_NAME.
> Note also that DRDA does not provide WITH TIMEZONE variants of its TIME and TIMEZONE
types. Some creativity would be required here too.
> Users are welcome to vote for this issue in order to boost its chance of being addressed.

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

View raw message