Epoch time to GMT, UTC, IST

[AKPWZ]

Hi everyone,

Just wanted to check if we can convert epoch time into different timezones such as GMT, UTC, IST, etc.?

What methods or functions can be used for this conversion?

Thank you 

[AKPWZ]

Wow @SeanAdams thank you so much. A big help 

[AKPWZ]

Hi @binuacs , can you please help me to modify my formula to match yours?

DateTimeDiff(DateTimeAdd(DateTimeToday(),-1,'days'),'1970-01-01 05:30:00','seconds') into IST?

This output is in epoch/unix, which I also want, but in IST (epoch).

Your Formula : DateTimeAdd('1970-01-01',([start])+19800, 'Seconds')

And I'm trying something like this but its not working for me, surely I'm doing something wrong here.
DateTimeDiff(DateTimeAdd(DateTimeToday(),-1,'days'),'1970-01-01'+(19800), 'Seconds')

Thanks

[binuacs]

@AKPWZ  using this formula DateTimeDiff(DateTimeAdd(DateTimeToday(),-1,'days'),'1970-01-01 05:30:00','seconds') into IST what would be the expected result or can you explain to me the actual output you are looking for, so that i can update the formula

[AKPWZ]

Hi @binuacs thank you.
Yes, I have tried it myself and it worked, but I was wondering if I could use your formula instead of  DateTimeDiff(DateTimeAdd(DateTimeToday(),-1,'days'),'1970-01-01 05:30:00','seconds'). to get the same result.