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.
This thread should help you a lot: Convert Unix Timestamp
Retrieving data ...