mahara-contributors team mailing list archive

[Chris O'Connor <681385@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
Date of birth is shown out by one day in day light saving
https://bugs.launchpad.net/bugs/681385
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.

Status in Mahara ePortfolio: New

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