I have a timestamp, this timestamp always has to be "yesterday", and it's
time part has to be at 08:30. I tryed something like
DATEADD('DAY', -1, TIMESTAMPADD('MINUTE', TIMESTAMPDIFF('MINUTE',
CURRENT_TIME, '08:30:00'), CURRENT_TIMESTAMP))
but H2 says that "Cannot parse "TIMESTAMP" constant "08:30:00"; SQL
statement".
I don't want to do it in java, do you know some way to set time? Thanks:)
--
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.
