UNIX2DATE(t)
t: Unix time stamp
The UNIX2DATE function translates Unix timestamps into the corresponding date. A Unix timestamp is the number of seconds since midnight (0:00) of January 1st, 1970 GMT.
DATE2UNIX, DATE.