Here, we have added a new Date function (DATE_ADD()) :-

Epoch :- The date and time in a computer is determined according to the number of seconds or clock ticks that have elapsed since the defined epoch for that computer or platform.  

Epoch time is defined as "The number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). 

Speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch' is often used as a synonym for 'Unix time'.

DATE_ADD() function is used when a number of records contain epoch/unix times by adding seconds to 1/1/1970. 

The formula is below - 

DATE_ADD("01/01/1970",{Epoch Time},"seconds")

Here is the example :-


IMAGE