fix time from received timestamp

diff --git a/fix-time.sql b/fix-time.sql
new file mode 100644 (file)
index 0000000..686d471
--- /dev/null
+++ b/fix-time.sql
@@ -0,0 +1,5 @@
+select _id, time,to_timestamp((json->>'received')::int8/1000) as received from eg5120 where to_timestamp((json->>'received')::int8/1000) - time > interval '1 second';
+
+begin;
+
+update eg5120 set time=to_timestamp((json->>'received')::int8/1000) where _id in ( select _id from eg5120 where to_timestamp((json->>'received')::int8/1000) - time > interval '1 second' );