db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Eder <lukas.e...@gmail.com>
Subject Re: Date manipulation in Derby
Date Tue, 03 May 2011 11:52:30 GMT
> 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'))

Mime
View raw message