Converting unix and epoch time in Airtable
  • 11 Dec 2023
  • 1 Minuto para leer
  • Oscuro
    Ligero
  • PDF

Converting unix and epoch time in Airtable

  • Oscuro
    Ligero
  • PDF

The content is currently unavailable in Spanish. You are viewing the default English version.
Article Summary

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). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch' is often used as a synonym for 'Unix time'.

So, if you have a number of records containing epoch/unix times, you can use a DATEADD() function in a formula field to convert that to a more friendly date by adding however many seconds (as specified by your epoch time string) to 1/1/1970.

Here's an example using the formula below:

DATEADD('1/1/1970',{Epoch Time},'seconds')
Screen Shot 2019-04-22 at 3.45.02 PM


¿Te ha sido útil este artículo?