Loading

Dates Display in Unix Time Instead of Date or Datetime

Publiseringsdato: Feb 26, 2026
Beskrivelse
A datetime field is displayed as a number or string in Tableau.

Cause

The datetime field uses the Unix time format. Tableau Desktop does not automatically convert this time format into a date or datetime format.
Løsning

To convert the field to UTC time, use the following calculation:

DATEADD('second', [Unix time field], #1970-01-01#)


To convert the field in Unix time to a different time zone, use the following calculation:

DATEADD('minute', INT([Unix time field]/60 + <UTC offset in minutes>), #1970-01-01#)


For example, to convert the field in Unix time to India Standard Time (IST), use the following calculation:

DATEADD('minute', INT([Unix time field]/60 + 330), #1970-01-01#)


Note: Both the above options assume that the Unix time field is in seconds. If the field is in milliseconds, convert it by dividing the field by 1000.
Knowledge-artikkelnummer

001473641

 
Laster
Salesforce Help | Article