Subtract hours from the now() function
Answer for timestamp You need to understand the nature of the data types timestamp (timestamp without time zone) and timestamptz (timestamp with time zone). If you don’t, read this first: Ignoring time zones altogether in Rails and PostgreSQL The AT TIME ZONE construct transforms a timestamp to timestamptz, which is almost certainly the wrong move … Read more