Extract Date from Epoch

#1

I have an epoch field that represents time down to seconds granularity. I want to deduce a second field based on it, that represents the date associated with it. For example, if the field named epoch_value had a value of 1493701494, which corresponds to May 2 2017 5:05:54PM, then I should be able to derive the corresponding value for the field named date_field as May 2 2017, using some formula on the epoch field.

Looks like the reverse is possible but not this?

#2

Why don’t you just do it in ruby as a function. Something like:

require ‘date’
DateTime.strptime(“1318996912”,’%s’)