title: How to truncate date in PostgreSQL?
body: <p>I'm trying to select all transactions in PostgreSQL 9 that happened earlier than the end of the last week. Which date function I should use to build such an interval?</p>