Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1082)
Subject: Re: TIME/TIMEZONE WITH TIMESTAMP, was:
From: Lance Andersen <Lance.Andersen@oracle.com>
In-Reply-To: <4D08C599.2030600@oracle.com>
Date: Wed, 15 Dec 2010 09:08:18 -0500
Content-Transfer-Encoding: quoted-printable
Message-Id: <2A992A88-0756-4F31-B335-C0A4AA47CE42@oracle.com>
References: <614C529D389A5944B351F7DFB7594F24F34DC8@uksrpblkexb01.detica.com>
 <4D08C599.2030600@oracle.com>
To: derby-dev@db.apache.org

Currently, there is no support for  SQL Data types which support =
TimeZone in JDBC.  If JSR 310 becomes part of Java SE, we provide =
support through it for these data types.  Currently JSR 310 is not final =
and that is something else that would be required.

Once the plans for JSR 310 are clarified, I can provide you with more =
guidance as to how JDBC will support TimeZone based data types.

Regards
Lance
On Dec 15, 2010, at 8:41 AM, Rick Hillegas wrote:

> Hi Greg,
>=20
> I responded on https://issues.apache.org/jira/browse/DERBY-4611. This =
would be a useful feature. Whoever picked it up would probably want to =
consult with the JDBC expert group to see if they think JSR 310 will =
have any implications for these new datatypes. So far, however, no-one =
has indicated that they plan to work on this for the next feature =
release: =
http://wiki.apache.org/db-derby/DerbyTenEightOneRelease#A10.8.1_Work
>=20
> Thanks,
> -Rick
>=20
> On 12/15/10 4:35 AM, Gregory Tarr wrote:
>>=20
>> Hello
>> Is there a plan to support timezones in derby? I've seen DERBY-4611 =
but there haven't been any recent comments on this. In particular a =
TIMESTAMP WITH TIME ZONE similar to Oracle's would be handy.
>>=20
>> Thanks
>> Greg
>>=20
>> Please consider the environment before printing this email.
>>=20
>> This message should be regarded as confidential. If you have received =
this email in error please notify the sender and destroy it immediately.
>> Statements of intent shall only become binding when confirmed in hard =
copy by an authorised signatory.  The contents of this email may relate =
to dealings with other companies within the Detica Limited group of =
companies.
>>=20
>> Detica Limited is registered in England under No: 1337451.
>>=20
>> Registered offices: Surrey Research Park, Guildford, Surrey, GU2 7YP, =
England.
>>=20
>=20