【PostgreSQL】datetime型変換に苦しむ

posts table column: posted_at: timestamp without timezone型

DATE(posts.posted_at AT TIME ZONE 'JST') AS posted_atするといいみたい


[https://qiita.com/kymmt90/items/181df6bf3d3399f299a8:embed:cite]