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.
