Worth noting, there's an in-depth discussion of how Mahara handles time values here: https://mahara.org/interaction/forum/topic.php?id=6045#post25831
And, indeed, it is written with the assumption that the (no-TZ) timestamp stored in the DB will have the database server's timezone applied to it implicitly, before the "extract epoch" operation. So if that behavior has changed in Postgres 9.2 then we certainly do need to be ready for that. -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1353069 Title: db_format_tsfield() returning time value with offset on POstgres Status in Mahara ePortfolio: In Progress Bug description: On postgres db_format_tsfield() calculates time by doing FLOOR(EXTRACT(EPOCH FROM {$field})) which apparently doesn't make sense if we are using fields without timezone (by reading this http://postgresql.1045698.n5.nabble.com/Possible-problem-with-EXTRACT- EPOCH-FROM-TIMESTAMP-td2125933.html). To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1353069/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
