# 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(":", "-")