SELECT now()::timestamp;
The cast converts the timestamptz returned by now() to the corresponding timestamp in your time zone – defined by the timezone setting of the session. That’s also how the standard SQL function LOCALTIMESTAMP is implemented in Postgres.
If you don’t operate in multiple time zones, that works just fine. Else switch to timestamptz for added_at. The difference?
- Ignoring time zones altogether in Rails and PostgreSQL
BTW, this does exactly the same, just more noisy and expensive:
SELECT now() AT TIME ZONE current_setting('timezone');