How do I convert a timestamp to another timezone with SQL?

Have you ever had that request? I would like to have the distribution of clicks per hour for the last week inĀ local time It's a no brainer if your database server is in the same time zone as your business audienceĀ  - then you just need to aggreate the clicks' timestamps to an hour. Not … Continue reading How do I convert a timestamp to another timezone with SQL?