Re: Date manipulation in Derby

[Rick Hillegas]

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