mythsymlink: print times in Sydney timezone instead of UTC

diff --git a/mythsymlink b/mythsymlink
index 42a4f9bdf45e04a151387ea1cd9b8009da9b645d..2bd754e24bbf3ddf75a843bd1616624772519ab3 100755 (executable)
--- a/mythsymlink
+++ b/mythsymlink
@@ -51,8 +51,14 @@ recordingsdir = cursor.fetchone()["data"]
 
 # Now find all the recordings we have at the moment
 cursor.execute("""
-    SELECT title, subtitle, starttime, basename, watched FROM recorded
-""")
+    SELECT
+        title,
+        subtitle,
+        CONVERT_TZ(starttime, 'UTC', '%s') as starttime,
+        basename,
+        watched
+    FROM recorded
+""" % "Australia/Sydney")
 for row in cursor:
     title = row["title"]
     starttime = str(row["starttime"]).replace(":", "-")