Hello.
This function in H2 does not have exact return type, it may return
TIMESTAMP, TIMESTAMP WITH TIME ZONE, DATE, or TIME depending on type of the
second argument. That's why its return type is not defined. You can add an
explicit cast.
SELECT CAST(DATE_TRUNC('MONTH', column) AS TIMESTAMP)
This construction looks ugly, but it should return an expected column type
in meta data.
--
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.
