db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Date manipulation in Derby
Date Tue, 03 May 2011 12:46:19 GMT
On 5/3/11 4:52 AM, Lukas Eder wrote:
>> Derby supports the JDBC escape function TIMESTAMPADD, documented here:
>> http://db.apache.org/derby/docs/10.8/ref/rrefjdbc88908.html
>>
>> Example:
>>
>> ij>  values {fn timestampadd(SQL_TSI_DAY, 1, timestamp('2010-12-31 23:59:59'))};
> Are there any plans to make this function available in a more regular
> syntax? Or what are the reasons that this is only possible using this
> "JDBC escape function" syntax? I'd expect this to be possible too:
>
> timestampadd(SQL_TSI_DAY, 1, timestamp('2010-12-31 23:59:59'))
>
Hi Lukas,

I don't see an existing JIRA for this issue. Feel free to log one.

Thanks,
-Rick


Mime
View raw message