Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
From: Knut Anders Hatlen <knut.hatlen@oracle.com>
To: derby-user@db.apache.org
Subject: Re: Date manipulation in Derby
References: <BANLkTim5ypqQcdqjA9LcBmA_v5nC=aRFuw@mail.gmail.com>
	<wjo8mxj42ei5.fsf@oracle.com>
	<BANLkTinGCn91_9Ovv_E0tNr1k6ZpaN6G6Q@mail.gmail.com>
	<4DBFF91B.5080200@oracle.com> <x6zkn24b8u.fsf@oracle.com>
Mail-Followup-To: derby-user@db.apache.org
Date: Wed, 04 May 2011 21:01:42 +0200
In-Reply-To: <x6zkn24b8u.fsf@oracle.com> (Dag H. Wanvik's message of "Wed, 04
	May 2011 19:38:25 +0200")
Message-ID: <x6aaf2cmsp.fsf@oracle.com>
User-Agent: Gnus/5.110016 (No Gnus v0.16) Emacs/24.0.50 (usg-unix-v)
MIME-Version: 1.0
Content-Type: text/plain

dag.wanvik@oracle.com (Dag H. Wanvik) writes:

> Rick Hillegas <rick.hillegas@oracle.com> writes:
>
>> I don't see an existing JIRA for this issue. Feel free to log one.
>
> Rick, do you know if there is a standard way of doing this (beyond the
> JDBC escape function)? I didn't find anything in the standard. It could
> be that this is one of those things that are not standardized and the
> presence of the JDBC escape is there to cover for vendors differing
> implementations of this. If so, we would be hestitant to add this unless
> most major vendors agreed on this syntax.

Hi Dag,

SQL:2003, part 2, has a section 4.6.4 Operations involving datetimes and
intervals. If my understanding is correct, databases that support
intervals would allow you to write things like:

  VALUES TIMESTAMP('2010-12-31 23:59:59') + INTERVAL '1' DAY

-- 
Knut Anders