My apologies, you are correct. Care to have a bash at implementing this? The parsing code is really easy to work with, straightforward recursive-descent parser. Just search for "TRUNCATE" and and start with making "TRUNC" an alias.
On Fri, Apr 20, 2012 at 15:27, Lukas Eder <[email protected]> wrote: > Hmm, not sure what you mean by "table modification method". You mean > the TRUNCATE statement? > > I didn't find any TRUNC() function in H2: > http://www.h2database.com/html/functions.html#trunc > > Only TRUNCATE() (on numbers, not dates): > http://www.h2database.com/html/functions.html#truncate > > So actually, yes, it would be lovely if TRUNC() / TRUNCATE() also > supported truncating dates, the way Oracle does, for instance :-) > > 2012/4/20 Noel Grandin <[email protected]>: >> TRUNC() is a scalar function that operates on values like dates. >> TRUNCATE is table modification method. >> They have nothing to do with each other besides the naming similarity. >> >> But yes, it would be nice to support it. >> Patches are welcome. >> >> On 2012-04-20 15:15, Lukas Eder wrote: >>> >>> Hello, >>> >>> This is a minor issue. I've found that many other databases support TRUNC >>> and TRUNCATE equally. H2 only has TRUNCATE: >>> http://www.h2database.com/html/functions.html#truncate >>> >>> Adding TRUNC() as an alias/synonym might be useful for increased >>> compatibility with >>> >>> - CUBRID >>> - DB2 >>> - HSQLDB >>> - Ingres >>> - Oracle >>> - Postgres >>> >>> Cheers >>> Lukas >>> -- >>> 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/-/FOkozo4knkAJ. >>> 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.
