sqltimestamph2

how to check timestamp in h2 database

need to check date value in h2 database. I'm using as below. but it is giving error.

where lim.REVIEW_DATE >= TIMESTAMP  20220606

Please suggest the correct syntax

Solution

  • You need to use standard literals:

    DATE '2022-06-06' for values of DATE data type.

    TIMESTAMP '2022-06-06 00:00:00' for values of TIMESTAMP data type.