Converting PostGreSQL Date time field at the import using SQL Statement

Hi folks, I am quite new to the forum and hopefully could find some hints. I am using a PostGreSQL db as data source and would like to convert the table epoch dates upfront at the import. This will ...