Changes between Version 3 and Version 4 of OpenCellID

Timestamp:

04/06/25 23:44:13 (3 months ago)

Author:

krit

Comment:

--

OpenCellID

@@ -38 +38 @@
 ~]$ 
 }}} 
+
+If use sqlite3 command, we can query to change epoch time to  date time.
+{{{
+sqlite> SELECT 
+    lat, 
+    lon, 
+    datetime(created_at, 'unixepoch', 'localtime') AS created_local, 
+    datetime(updated_at, 'unixepoch', 'localtime') AS updated_local
+FROM cell WHERE mcc='520' AND mnc='3' AND lac='842' AND cellid='164612740';
+13.7159|100.6512|2025-02-14 10:19:55|2025-04-05 16:59:02
+sqlite>
+}}}