How to convert epoch time to human readable in teradata?

@addison 

In Teradata, you can convert epoch time to human readable format using the following SQL query:

1
2
3
4

SELECT 
  TIMESTAMP '1970-01-01 00:00:00' + (YourEpochTimeInSeconds * INTERVAL '1' SECOND)
FROM 
  YourTable;

Replace YourEpochTimeInSeconds with the epoch time you want to convert and YourTable with the table where the epoch time is stored. This query will return the epoch time in human readable format.