How to remove TIME on Epoch in SQL Server

Question

How to remove TIME on Epoch format in SQL Server?

Example: 2713795200000 should return Thu, 30 Dec 2055 00:00:00 instead of Thu, 30 Dec 2055 16:00:00 GMT.

`CAST` it as a date and then back to datetime? – Ben Thul May 19 '16 at 04:48 — Ben Thul, May 19 '16 at 04:48

score 0 · Accepted Answer · answered May 19 '16 at 05:54

0

You can use below query for your problem. May be its helps you.

SELECT  DATEADD(DAY, (2713795200000)/(1000*60*60*24), '19700101')

answered May 19 '16 at 05:54

Sandeep Kumar

Thanks sir! you could also answer my question here http://stackoverflow.com/questions/37300536/convert-epoch-to-datetime-sql-server-exceeds-year-2038/37300753?noredirect=1#comment62124520_37300753 – Dobermaxx99 May 19 '16 at 23:22
@Dobermaxx99 Your Welcome : ) – Sandeep Kumar May 20 '16 at 04:39

1 Answers1