H2 数据库存在 SQL INTERVAL 精确问题

发布于 2025-01-13 06:03:34 字数 371 浏览 4 评论 0原文

我正在使用 Exasol DB 并执行日期操作，我使用 SQL INTERVAL 关键字精确。

例如此查询：

SELECT email_staging.ID, email_staging.CREATED_AT from EMAIL email_staging  
WHERE email_staging.CREATED_AT > (CURRENT_DATE - (INTERVAL '5' DAY(3) ) ) )

Exasol 要求在 DAY 之后发送 ie 后缀如“(3)”的精度，否则将不允许查询超过 99 天。但H2数据库不支持精确的INTERVAL。

有没有人解决这个问题，因为我使用 H2 DB 的集成测试无法运行。

原文

I am using Exasol DB and to perform date operation, I am using SQL INTERVAL keyword with precision.

For example this query:

SELECT email_staging.ID, email_staging.CREATED_AT from EMAIL email_staging  
WHERE email_staging.CREATED_AT > (CURRENT_DATE - (INTERVAL '5' DAY(3) ) ) )

Exasol requires the precision to sent i.e. suffix like '(3)' after DAY or else it won't allow querying for more that 99 days. But H2 Database doesn't support INTERVAL with precision.

Has anyone solved this as my integration tests which use H2 DB can't run.

分享到QQ

分享到微博