Hi Guys,
Can anyone help me how to convert Unix Ephoc time to actual time, this is is because i need to calculate the days difference between two ephoc date fields.
I found this in a post: https://community.alteryx.com/t5/Data-Preparation-Blending/Does-Alteryx-allow-you-to-convert-Unix-Epoch-time-to-another/m-p/13432#M2462
Unix Epoch time is number of seconds since '1970-01-01 00:00:00'The function DATETIMEADD() is what you needDATETIMEADD('1970-01-01 00:00:00', [Unix Epoch Time], 'seconds')
@michael_treadwell solved it
DATETIMEADD('1970-01-01 00:00:00', [Unix Epoch Time], 'seconds')
This above format is not working.. What should be value in [Unix Epoch Time]
When I run
DATETIMEADD('1970-01-01 00:00:00',[time],'seconds')
I get the following error message
"Warning: Formula (5): Interval out of range for DateTimeAdd: 1499537667000.000000 Record #1 in field date_time"
for all rows.
What does this error message mean?
I solved the issue. My unix time had 11 digits instead of 10. I trimmed the final number and the formula worked. I'll need to go back and check to see why the trim is needed and how it effects the actual date.
Hi
Not sure if this is still an issue for you,
I had a similar issue and figured out the timestamp is returning in milliseconds as opposed to seconds. So rather than trim just convert to seconds.
Cheers
Gavin
