I use H2 for testing and I want to set sysdate.
I tried to create an alias for sysdate to my own implementation, but then I
couldn't use it with arithmetic like sysdate - ?. There was exception: Unknown
data type: "?"
I tried to replace sysdate string to smth like timestamp '2018-01-01
11:11:11.123' or parsedatetime('2018-01-01 11:11:11.123', 'yyyy-MM-dd
hh:mm:ss.SSS') in runtime. There was same exception, like in previous
attempt.
Yes, I can add cast(? as number) to all my sql, but it isn't a good
solution for me.
Do you have any idea, how can I do this?
ps: I also use Spring. Maybe it will help
--
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
