Answers for "epoch timestamp to date in sql"

SQL
1

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
Posted by: Guest on November-16-2020

Code answers related to "epoch timestamp to date in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language