Hi Thomas, Thank you for the response. The jar in my classpath is 'h2-1.3.149.jar' which i believe is the beta version. i will get the latest jar and try the functionality.
Regards, Karthik On Friday, September 21, 2012 3:22:22 PM UTC-5, Thomas Mueller wrote: > > Hi, > > You are using an old version of H2 (1.3.149 Beta from 2011-01-07) where I > believe this function is not supported yet. You need to use a more recent > version of H2. And (not sure why) you need to use the keyword 'timestamp' > so that the parser knows it's a timestamp: > > select TIMESTAMPADD(SECOND, 7, current_timestamp()) > timestamp > '2012-09-21 15:14:28.399' > > Regards, > Thomas > > On Fri, Sep 21, 2012 at 10:18 PM, karthik cherukuri > <[email protected]<javascript:> > > wrote: > >> When i try to use TIMESTAMPADD method in H2 DB (as MySQL supports the >> same), i am getting the below error. The same works fine in MySql >> >> select TIMESTAMPADD(SECOND, 7, current_timestamp()) > '2012-09-21 >> 15:14:28.399'; >> Function "TIMESTAMPADD" not found; SQL statement: >> select TIMESTAMPADD(SECOND, 7, current_timestamp()) > '2012-09-21 >> 15:14:28.399' >> [90022-149]<http://localhost:8082/query.do?jsessionid=ee18fe13498adc4a6793db3c0c73ee09#> >> >> 90022/90022 >> (Help)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90022> >> >> Help please... >> >> Thanks, >> Karthik >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/h2-database/-/nsV3EpIhBkwJ. >> To post to this group, send email to [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/btWhZc69vu0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
