hezjing <[email protected]> writes: > Hi > > > With MySQL, I can actually manipulate the date using the built-in > function like: > > SELECT DATE_ADD('2010-12-31 23:59:59', INTERVAL 1 DAY) > > May I know if there is similar function in Derby? How do we manipulate > the date in Deby?
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'))}; 1 ----------------------------- 2011-01-01 23:59:59.0 1 row selected -- Knut Anders
