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] > 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]. > 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. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
