Converting Epoch Time to normal time and keeping decimal precision

Question

Hello all!

I am converting Epoch Time to readable time with a DateTimeAdd function and its working except I need it more precise.

My original timestamps are in the form of 1681412524.10937 (all those decimal points!) and using the function:

DATETIMEADD('1970-01-01 00:00:00', Tonumber([Timestamp]), 'seconds')

It obviously loses lots of information going to only seconds, is it possible to retain the decimal points in any way converting out of Epoch time? Thanks !!

nbb623 · Answer

Thanks that seems like it would work! I'm still very new to this program, what would be the optimal way to add the decimal back to the end of the new datetime?

FrederikE · Answer

Hey @nbb623,

You can split out everything after the decimal point using RegEx (.*\.(.*)). And then use your DateTimeFunction afterwards.