From derby-user-return-8833-apmail-db-derby-user-archive=db.apache.org@db.apache.org Sun Mar 09 18:51:11 2008 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 21927 invoked from network); 9 Mar 2008 18:51:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Mar 2008 18:51:11 -0000 Received: (qmail 12982 invoked by uid 500); 9 Mar 2008 18:51:07 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 12960 invoked by uid 500); 9 Mar 2008 18:51:07 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 12949 invoked by uid 99); 9 Mar 2008 18:51:07 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Mar 2008 11:51:07 -0700 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.98.31] (HELO brmea-mail-1.sun.com) (192.18.98.31) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Mar 2008 18:50:18 +0000 Received: from dm-uk-01.uk.sun.com ([129.156.101.115]) by brmea-mail-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id m29IocXc009887 for ; Sun, 9 Mar 2008 18:50:38 GMT Received: from barman.uk.sun.com (barman.UK.Sun.COM [129.156.132.12]) by dm-uk-01.uk.sun.com (8.13.7+Sun/8.13.7/ENSMAIL,v2.2) with ESMTP id m29Iob0E022742 for ; Sun, 9 Mar 2008 18:50:37 GMT Received: from vpn-129-150-121-21.uk.sun.com ([129.150.121.21]) by barman.uk.sun.com with esmtp (Exim 4.42) id 1JYQaz-00032M-G3 for derby-user@db.apache.org; Sun, 09 Mar 2008 18:50:05 +0000 Message-ID: <47D43179.9040101@sun.com> Date: Sun, 09 Mar 2008 18:50:33 +0000 From: Alan Burlison User-Agent: Thunderbird 2.0.0.9 (X11/20080213) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Moving a Derby database across timezones References: <47D32EA6.9000908@sun.com> <47D342A9.9080806@apache.org> <47D3BBB3.2030207@sun.com> <47D40C36.8020500@amberpoint.com> In-Reply-To: <47D40C36.8020500@amberpoint.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Bryan Pendleton wrote: >>> of the SQL standard foundation document) Derby's TIMESTAMP is >>> >>> TIMESTAMP WITHOUT TIME ZONE >> >> Yeah, I figured as much. The spec gives you a choice of with/without >> timezone, and Derby implements the broken one. > > Perhaps you could contribute an implementation of the other style > of timestamp, then Derby would have both. Perhaps, if I had time. Unfortunately I don't. -- Alan Burlison --