redshift timestamp with timezone to date code example
Example: convert time zone redshift
CONVERT_TIMEZONE ( ['source_timezone',] 'target_timezone', 'timestamp')
CONVERT_TIMEZONE ( ['source_timezone',] 'target_timezone', 'timestamp')