Forum Discussion
Change Epoch datetime to GMT + 5.30
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
3 Replies
- samratpbi
Super User
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!
