How to get Date and Time as seperate fields from UNIX timestamp field?

[jblomqvist]

Hello there,

I have a UNIX timestamp format field.

The field is called Unix

An example value is this: 1499367403

How can I create two fields, one with the date, and the other containing the time? It should be in GMT+1 timezone.

[petter]

This thread should help you a lot: