在查询条件下选择日期和小时

Question

我在Postgres数据库上使用PGADMIN 4。我想使用以下查询提取，但也要添加小时。例如，凌晨6点的当前日期。

谢谢

SELECT object_key, audited_changes, created_at
FROM pg_audits
WHERE
source_action = 'funding' AND
created_at >= CURRENT_DATE -1 AND
created_at < CURRENT_DATE
ORDER BY
created_at DESC

Answer 1

您可以编写任何数量的小时代替N

SELECT object_key, audited_changes, (created_at + INTERVAL 'N HOURS') as created_at 
FROM pg_audits
WHERE
source_action = 'funding' AND
created_at >= CURRENT_DATE -1 AND
created_at < CURRENT_DATE
ORDER BY
created_at DESC