Convert unix time to datetime in redshift

select (timestamp ’epoch’ + unix_time_col * interval ‘1 second’)::datetime

https://stackoverflow.com/questions/39815425/how-to-convert-epoch-to-datetime-redshift