Hi, brother, I have encountered a confusing problem regarding Postgres data integration. I want to execute this statement every two minutes to retrieve the latest results from the database, so I use the following statement for filtering. SELECT history_uint.itemid, history_uint.value, interface.ip, items.name, hosts.host, TO_TIMESTAMP(history_uint.clock) AS clock_datetime FROM history_uint JOIN items ON history_uint.itemid = items.itemid JOIN hosts ON items.hostid = hosts.hostid JOIN interface ON interface.hostid = hosts.hostid WHERE history_uint.clock > (FLOOR(EXTRACT(EPOCH FROM NOW())) - 120) AND items.flags = 4 AND (items.name LIKE '%Bits sent%' OR items.name LIKE '%Bits received%') AND (hosts.host LIKE 'CN%' OR hosts.host LIKE 'os%') ORDER BY history_uint.clock DESC LIMIT 90000;  This SQL statement executes perfectly in database tools However, this SQL statement cannot be executed in dbxquery, and the error is unknown I found that the key reason is the following SQL statement: Among them, history_uint.clock>(FLOOR (EXTRACT (EPOCH) FROM NOW（））） - 120） When I replaced (FLOOR (EXTRACT (EPOCHFAM NOW()) -120) with Unix timestamps, everything was fine I tried to replace it with other SQL statements, but they all failed. Please help me analyze this issue together. thank you. Add some environmental information: Postgres version: 14.9 Java version 21.0.5 DB connet version 3.18.1 Postgres JDBC version 1.2.1 thank you ... View more

嗨，兄弟， 我遇到了一个关于 postgres 数据集成的令人困惑的问题。 我想每两分钟执行一次此语句，以便从数据库中获取最新结果，因此我使用以下语句进行筛选。 SELECT history_uint.itemid，history_uint.value，interface.ip，items.name，hosts.host，TO_TIMESTAMP （history_uint.clock） AS clock_datetime FROM history_uint JOIN items ON history_uint.itemid = items.itemid JOIN hosts ON items.hostid = hosts.hostid JOIN interface ON interface.hostid = hosts.hostid WHERE history_uint.clock > （FLOOR（EXTRACT（EPOCH FROM NOW（））） - 120） AND items.flags = 4 AND （items.name LIKE '%Bits sent%' OR items.name LIKE '%Bits received%'） AND （hosts.host LIKE 'CN%' OR hosts.host LIKE 'os%'） ORDER BY history_uint.clock DESC LIMIT 90000; 此 SQL 语句在数据库工具中完美执行 但是，此 SQL 语句无法在 dbxquery 中执行，错误未知 我发现关键原因是以下 SQL 语句： 其中 history_uint.clock > （FLOOR（EXTRACT（EPOCH FROM NOW（））） - 120） 当我用 Unix 时间戳替换 1 时，一切都很好 我尝试用其他 SQL 语句替换它，但它们都失败了。 请帮我一起分析这个问题。谢谢。 添加一些环境信息： Postgres 版本：14.9 java 版本 21.0.5 DB connet 版本 3.18.1 postgres JDBC 版本 1.2.1 谢谢     ... View more