Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have rquirement to change the Epoch datetime to readable format , i am using the below query which is giving me right answer for GMT +5.00 & when i add GMT +5.30 it gives a error..
each #datetime(1970,1,1,0,0,0) +#duration(0,+(5),0,[clock])) - Get result
each #datetime(1970,1,1,0,0,0) +#duration(0,+(5.30),0,[clock])) - Error
looking for help
Thanks
Solved! Go to Solution.
Thanks , that worked
Great!
if that helps to resolve your problem, then please mark my reply as a solution provided, that would help others also to find solution, thanks!
Hi,
I do not have sample data, however looking into the code above, it seems what needs to be done is like this below:
each #datetime(1970,1,1,0,0,0) +#duration(0,5,30,[clock]))
In #duration, days, hours, minutes, secords are different fields.
Hope this helps.
If this helps to resolve your problem, then please mark it as solution, Thanks!