It does not matter, neither built-in date-time function nor alias for date-time function nor other date-time value cannot be used together with parameter in subtraction operation in H2. This is a known limitation.
To use such arithmetic operation parameter should be wrapped in CAST operator or in CONVERT() function if compatibility with some other database that don't have CAST operator is required. Similar issue was recently reported on GitHub: https://github.com/h2database/h2database/issues/1383 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
