Reviewed: https://reviews.mahara.org/3973 Committed: http://gitorious.org/mahara/mahara/commit/aa0105e6f5c1a02930e5d79a60ddc88ce5934af0 Submitter: Aaron Wells ([email protected]) Branch: 1.9_STABLE
commit aa0105e6f5c1a02930e5d79a60ddc88ce5934af0 Author: Yuliya Bozhko <[email protected]> Date: Wed Aug 6 07:47:36 2014 +1200 Fix db_format_tsfield() returning value with offset on Postgres 9.2 and later (Bug #1353069) Change-Id: I827851a16eba74d474234c21dd6b6afc2d06470c Signed-off-by: Yuliya Bozhko <[email protected]> -- 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: Fix Committed Status in Mahara 1.10 series: Fix Committed Status in Mahara 1.8 series: Fix Committed Status in Mahara 1.9 series: Fix Committed Status in Mahara 15.04 series: Fix Committed 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
