Differences

This shows you the differences between two versions of the page.

--- onny:notizen:programmierung [2026/08/18 11:13] – [nextcloud app dev] fdc9:281f:4d7:9ee9::1
+++ onny:notizen:programmierung [2026/08/18 11:23] (current) – [mariadb / mysql] fdc9:281f:4d7:9ee9::1
@@ Line 926: / Line 926: @@
 </code>
+sort column by timestamp and convert to datetime
+<code sql>
+SELECT
+    `id`,
+    `calendarid`,
+    FROM_UNIXTIME(`firstoccurence`) AS firstoccurence,
+    FROM_UNIXTIME(`lastoccurence`)  AS lastoccurence
+FROM `oc_calendarobjects`
+WHERE (`lastoccurence` < 1606694400)
+  AND (`firstoccurence` > 0)
+  AND (`componenttype` = 'VEVENT')
+ORDER BY `lastoccurence` DESC;
+</code>