mahara-contributors team mailing list archive

[Aaron Wells <1353069@xxxxxxxxxxxxxxxxxx>]

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