I am trying to extract the time from a timestamp in a redshift dataflow and cannot get the hours to extract correctly. My datetime field is in UTC and I need to convert the time zone to EST which is fine but when I try to get the time from the time stamp it returns the hours of the UTC time and not the converted timezone. Any help would be appreciated.
Screenshot below shows my first column stored in UTC, second column is the converted time zone and the following fields are my attempts to extract the time from the converted time zone value.