Alternative solutions would be to just cast to a date, but this requires a code change for existing applications. SELECT timestamp_column::DATE FROM table_name; Another solution could be a UDF, but ...
This is a UTC timestamp conversion tool. I made it because I routinely have to convert UTC to specific timezones and I got tired of either A) typing date commands or B) going to free websites to do ...