CODEWITHSUNDEEP
sqlpostgresqldatetimestamp
delalma
delalma

Reputation: 928

Select date and hour in query conditions

I am using PGADMIN 4 on postgres database. I would like to extract using the following query but adding hour as well. current date at 6am for example.

Thank you

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

Upvotes: 0

Views: 47

Answers (1)

Jay Shankar Gupta
Jay Shankar Gupta

Reputation: 6088

You can write any number of hours in place of 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

Upvotes: 1

Related Questions