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

    Converting unix and epoch time in Airtable

    • Oscuro
    • PDF

    The content is currently unavailable in Spanish. You are viewing the default English version.
    Resumen del artículo

    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')
    Plain text
    Screen Shot 2019-04-22 at 3.45.02 PM


    ¿Te ha sido útil este artículo?