Sql server epoch to datetime

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

Similar codes

0 vote158 views1 answer
How to run mysql on terminal mac
SQL
0 vote173 views1 answer
Login failed for user sql server
SQL
2 votes145 views1 answer
Enum in SQL Server
SQL
0 vote164 views1 answer
Sql waitfor
SQL
0 vote141 views1 answer
Number(10 2) in sql means
SQL
1 vote130 views1 answer
Error code 1175 mysql fix
SQL
10 votes147 views2 answers
Sql rtrim
SQL
0 vote155 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote103 views1 answer
Oracle function select into
SQL
2 votes181 views2 answers
Mysql search for column name in all tables
SQL