Change Epoch datetime to GMT + 5.30

[sivas07]

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

[sivas07 · Accepted solution]

Thanks , that worked 

[samratpbi]

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!

[samratpbi]

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!