SQL Server Tips
Wednesday, 8 February 2017
How to convert unixtime stamp in sql server
--How to convert unixTimestampt in SQL SERVER
DECLARE
@UnixTimeStamp
BIGINT
=
1480272249102285
SELECT
DATEADD
(
S
,
CONVERT
(
INT
,
LEFT(
@UnixTimeStamp
,
10
)),
'1970-01-01 '
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment