Convert UNIX/Epoch time to current date

Avatar

By Anjali Daga

updated about 1 month ago

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 :-


Did this answer your question?