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.
