Periscope Data Blog Manipulating Dates, Datetimes, Unix Timestamps, and Other Date Formatting Tricks in Redshift

Dates aren't stored in the database in the format you want to display? You can use the Redshift TO_CHAR() function to create a string-formatted extract in order to display dates however you want!