Loading

Dates Display in Unix Time Instead of Date or Datetime

Дата публикации: Feb 26, 2026
Описание
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.
Решение

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.
Дополнительные ресурсы

 

Номер статьи базы знаний

001473641

 
Загрузка
Salesforce Help | Article