Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 93633 invoked from network); 31 May 2005 21:20:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 May 2005 21:20:56 -0000 Received: (qmail 43131 invoked by uid 500); 31 May 2005 21:20:53 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 43038 invoked by uid 500); 31 May 2005 21:20:52 -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 42618 invoked by uid 99); 31 May 2005 21:20:52 -0000 X-ASF-Spam-Status: No, hits=1.0 required=10.0 tests=DNS_FROM_RFC_ABUSE,SPF_HELO_FAIL,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from e2.ny.us.ibm.com (HELO e2.ny.us.ibm.com) (32.97.182.142) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 31 May 2005 14:20:47 -0700 Received: from d01relay04.pok.ibm.com (d01relay04.pok.ibm.com [9.56.227.236]) by e2.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j4VLKjtX013901 for ; Tue, 31 May 2005 17:20:45 -0400 Received: from d01av01.pok.ibm.com (d01av01.pok.ibm.com [9.56.224.215]) by d01relay04.pok.ibm.com (8.12.10/NCO/VER6.6) with ESMTP id j4VLKjBU239556 for ; Tue, 31 May 2005 17:20:45 -0400 Received: from d01av01.pok.ibm.com (loopback [127.0.0.1]) by d01av01.pok.ibm.com (8.12.11/8.13.3) with ESMTP id j4VLKj9n019714 for ; Tue, 31 May 2005 17:20:45 -0400 Received: from d25ml01.torolab.ibm.com (d25ml01.torolab.ibm.com [9.26.6.102]) by d01av01.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j4VLKipN019409 for ; Tue, 31 May 2005 17:20:45 -0400 Subject: timezone support To: derby-user@db.apache.org X-Mailer: Lotus Notes Release 6.0.2CF1 June 9, 2003 Message-ID: From: Gin Ng Date: Tue, 31 May 2005 17:20:38 -0400 X-MIMETrack: Serialize by Router on D25ML01/25/M/IBM(Release 6.53HF247 | January 6, 2005) at 05/31/2005 17:20:44 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Is there timezone support in Derby? timezone_hour and timezone_minute are listed as SQL reserved words, but I could not find any other information about them. I need to do an insert of timestamp in GMT. I use "CURRENT TIMESTAMP - CURRENT TIMEZONE" in DB2 and "ALTER SESSION SET TIME_ZONE = '-0:0'; and SYSTIMESTAMP" in Oracle. Gin Ng