Currently in the database that I am pulling data from, all of the dates are formatted as numbers instead of dates. What I was told is that the number is the number of seconds from Jan 1, 1970. Our DBA told me to use this function, unixts_to_date, to convert the number to a date. The problem is that Tableau doesn't recognize the function.
Any other ideas (besides just doing the math in a calculated field) to get the number into a date?
Thanks
Kevin
답변 4개
One way to do is create the calculated field based on that data.
The following function works in Tableau
DATEADD('second',[Unix time],#January 1,1970#)
