79159635

Date: 2024-11-05 15:06:57
Score: 2
Natty:
Report link

create table tbA ( id int, jsonData varchar(max) )

insert tbA values (1,'{"updated_at":1664296267649490}') ,(2,'{"updated_at":1632984531588160}')

select id,DATEADD(SECOND, (cast(JSON_VALUE(jsonData,'$.updated_at') as bigint) / 1000000), '1970-01-01 00:00:00') as dateConverted from tbA

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