web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Converting unix time s...

Power Automate

Unanswered

Converting unix time stamp to date and time?

(0) Share

Report

Report

Posted on by MarkH1

69

Hi,

Has anyone figured out a solution for this one? I need to convert a unix time stamp to UTC.

Thanks,
M

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @MarkH1

Suggestion here https://powerusers.microsoft.com/t5/Building-Flows/Got-a-recipe-for-converting-a-unix-timestamp-to-a-utc-date/td-p/137246 is to use the following:

addseconds('1970-1-1', Div(timestamp,1000) , 'yyyy-MM-dd')

Learn something new every day... https://en.wikipedia.org/wiki/Unix_time

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report
I know this is old, but if anyone is just copy/pasting ... then ensuring that 'timestamp' (your source) is surrounded by an int() function cannot hurt any ...

However, I get more accurate results with the following (from here), @DamoBird365 ... am I going crazy?

addseconds('1970-1-1', int(UNIX_TIMESTAMP) , 'yyyy-MM-dd')

TBF - It probably depends on the type of UNIX timestamp. (sec/mili/micro)

Was this reply helpful? Yes No

Join the conversation