Lukas Eder <[email protected]> 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
