Forum Discussion
Converting timestamp fromI to Date/Time
How can I convert this data to a date, in our database I got this timestamp 1557280403. It is from a SQL server.
help wanted
If the timestamp is seconds since 1/1/1970, you can use the use the following function, call it GetDateTimeFromSeconds, then add a step in your query to create a column, calling this function, and passing in your timestamp
I can't take credit for this, got this from another helpful contributor to the community
Hope it helps,
//
// ...This function takes in seconds from epoch and returns a value in datetimezone (UTC)
//
let
Source = (seconds as number) =>
let
Result = #datetimezone(1970, 1, 1, 0, 0, 0, 0, 0) + #duration(0, 0, 0, seconds)
in
Result
in
Source
6 Replies
Hi Anonymous
You can use M to do it, as below#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, 1557280403)
Hope it helps
MariuszIf the timestamp is seconds since 1/1/1970, you can use the use the following function, call it GetDateTimeFromSeconds, then add a step in your query to create a column, calling this function, and passing in your timestamp
I can't take credit for this, got this from another helpful contributor to the community
Hope it helps,
//
// ...This function takes in seconds from epoch and returns a value in datetimezone (UTC)
//
let
Source = (seconds as number) =>
let
Result = #datetimezone(1970, 1, 1, 0, 0, 0, 0, 0) + #duration(0, 0, 0, seconds)
in
Result
in
Source
