Dobermaxx99
Reputation: 318
How to remove TIME on Epoch in SQL Server
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.
Upvotes: 0
Views: 353
Answers (1)
Sandeep Kumar
Reputation: 1202
You can use below query for your problem. May be its helps you.
SELECT DATEADD(DAY, (2713795200000)/(1000*60*60*24), '19700101')
Upvotes: 0
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to add a column with a default value to an existing table in SQL Server?
- How do I UPDATE from a SELECT in SQL Server?
- How to check if a column exists in a SQL Server table
- How can I remove duplicate rows?
- How can I list all foreign keys referencing a given table in SQL Server?
- How can I do an UPDATE statement with JOIN in SQL Server?
- DateTime2 vs DateTime in SQL Server
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How can I delete using INNER JOIN with SQL Server?