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 '
)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)