Loading

Dates Display in Unix Time Instead of Date or Datetime

Udgivelsesdato: 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.
Vidensartikelnummer

001473641

 
Indlæser
Salesforce Help | Article