title: How to select date with timezone in Postgresql?
body: <p>I want to retrieve the daily number of signups recorded in Berlin timezone, but by default my database is using timezone '-08'. How do I do a <code>select</code> statement while specifying timezone?</p>