db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: Date manipulation in Derby
Date Tue, 03 May 2011 12:42:51 GMT
Lukas Eder <lukas.eder@gmail.com> writes:

>> 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'm not aware of any plans to implement alternative syntax for
manipulating timestamps. The JDBC escape function syntax was probably
chosen because it was defined by a standard and therefore believed to be
more portable.

Knut Anders

View raw message