FROM_UNIXTIME

FROM_UNIXTIME https://mariadb.com/kb/en/from_unixtime/ FROM_UNIXTIME Returns a datetime from a Unix timestamp. mariadb.com The options that can be used by FROM_UNIXTIME(), as well as DATE_FORMAT() and STR_TO_DATE(), are: Option Description %a Short weekday name in current locale (Variable lc_time_names). %b Short form month name in current locale. For locale en_US this is one of: Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov or Dec. %c Month with 1 or 2 digits. %D Day with English suffix 'th', 'nd...

원문링크 : FROM_UNIXTIME