Teradata: Epoch Time To Timestamp

Teradata: Epoch Time To Timestamp

➩ Epoch Time is defined as the number of seconds that have elapsed since 00:00:00 time of 1 January, 1970 (1970-01-01 00:00:00).
➩ Every day is treated as if it contains exactly 86400 seconds


➠ Convert Epoch Time to TIMESTAMP(0): Below conditions should met to apply logic as explained in examples.

➠ Convert Epoch Time to TIMESTAMP(6): Below conditions should met to apply logic as explained in examples.