Date of birth is shown out by one day in day light saving

Bug #681385 reported by Chris O'Connor
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Low
Ruslan Kabalin

Bug Description

The date of birth is saved correctly in the database,
But when shown and the system is in daylight saving time (1 hour difference) it changes the display of the day back by 1 day

Code in lib/dml.php
$tsfield = "IF($field >= '1970-01-01', UNIX_TIMESTAMP($field), TIMESTAMPDIFF(SECOND, '1970-01-01', $field))";

Mahara version 1.3.2
Database Mysql
OS Debian

Revision history for this message
Ruslan Kabalin (rkabalin) wrote :

Hi Chris,

Such problem may pop-up when locale setting (Country setting in Mahara option) does not match your current location. Anyway, I fixed it the most obvious way.

Changed in mahara:
status: New → Fix Committed
assignee: nobody → Ruslan Kabalin (ruslan-kabalin)
importance: Undecided → Low
Changed in mahara:
milestone: none → 1.4.0
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.