Forum Discussion
Anonymous
7 years agoNot applicable
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
- 7 years ago
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 - Anonymous7 years ago
Hi
Thank you for the reply.
Can to translate it to DAX. (sorry but I am very new in this)
Mariusz
7 years agoCommunity Champion
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
Mariusz
- Anonymous7 years agoNot applicable
Hi
I got it works. thanks you very much.