Converts a number of seconds since year 0 to a DATETIME

FROM_SECONDS.sql

-- Converts a number of seconds since year 0 to a DATETIME
-- MySQL counterpart of TO_SECONDS() : https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_to-seconds
-- Author : sfaut <https://github.com/sfaut>
-- Publication date : 2023-03-05
-- Tested with MySQL 8.0.32 (@@sql_mode='ANSI,TRADITIONAL')

CREATE FUNCTION FROM_SECONDS(seconds BIGINT)
RETURNS DATETIME
DETERMINISTIC
COMMENT 'Converts a number of seconds since year 0 to a DATETIME'
RETURN DATE'0000-01-01' + INTERVAL seconds SECOND - INTERVAL 1 DAY;