79577580

Date: 2025-04-16 15:50:34
Score: 2
Natty:
Report link

I just use this to convert to your local time stamp.

SELECT dateadd(ss, -DATEDIFF(SS, GETDATE(), GETUTCDATE()) , dateadd(ms, [DateField] % 86400000,

dateadd(DAY, [DateField] / 86400000, '1/1/1970')))

FROM [SourceTable]

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: wolfsvein