sql epoch to datetime code example

Example: convert epoch to date in sql server

SELECT FROM_UNIXTIME(FLOOR(EPOCH_TIMESTAMP/1000)) FROM table; --if milliseconds
SELECT FROM_UNIXTIME(FLOOR(EPOCH_TIMESTAMP)) FROM table; --no milliseconds