Converting a UNIX timestamp to datetime

Question

Hi,

I have a live dataset that has a time field expressed in UNIX (The amount of seconds passed since 1 January 1970). 
I would like to add a new field to it containing the datetime of my timezone (GMT+1/Central Europe). The dialog box of Field Calculator (both default as Regular Expression) don't give much information on how to fill in values. Which of the two FC's can be used best for my task? And what does the function look like?

Regards,
Collin

DamasoAvalos_Ruiz1 · Answer

Hello,

Did you find any answer/solution for this?
I have exactly the same problem.
I think a toolbox should exist for this, if not, I will build one that takes a UNIX timestamp as input parameter and returns a date as output.

make sense? What do you think?

MarkBramer · Answer

Colin Cooper‌

Do you still need help on this?  If so, can you elaborate on what you want to do?  I don't really follow the original question.

In the meantime, GeoEvent has two internal functions you may be interested in:

1) receivedTime() - returns time stamp of when geoevent was received;

2) currentTime() - generates new time stamp at the moment when the Field Calculator evaluates the expression

Mark