Re: Implicit conversion of mysql TIMESTAMP type to Horde_Date

This is a multi-part message in MIME format.
--------------7D4A3F92F15B737C23899937
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


Am 07.01.19 um 16:25 schrieb Ralf Lang:
> Hi,
>
> I am currently a little puzzled by either Horde_Db or Horde_Rdo
> implicitly converting TIMESTAMP db fields to Horde_Date values.
> Unfortunately, it has the wrong idea about the timezone of TIMESTAMP.
>
> A timestamp stored as 2018-05-16 04:00:00 is returned as 2018-05-16
> 04:00:00 Europe/Berlin.
>
> The database time_zone is SYSTEM. The system timezone is UTC.
>
> To understand the issue better, I'd rather turn off the automatic
> conversion and do the conversion to Horde_Date manually. Is there any
> config for Horde_Db to govern this?


Looks like it's this line:
https://github.com/horde/Rdo/blob/5d16dda64ed249400b18ba4f62fcbcd3443d9d83/lib/Horde/Rdo/Mapper.php#L230

For a hotfix in my local issue, I may overload mapFields (60 loc) in the
derived Mapper. Still, I think assuming the backend data is always in
the frontend's default timezone might not always be right.


--------------7D4A3F92F15B737C23899937
Content-Type: application/pgp-keys;
 name="pEpkey.asc"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="pEpkey.asc"

-----BEGIN PGP PUBLIC KEY BLOCK-----

mQENBFvSz9ABCAC/D3VOv9UiDxS9rLwc2SYOKj7kg5ERpKULorWII7QcIc8PC5xt
OlxRxI8sg15y8JvtrPo8FJG9RfDiwbqrRSL4nzlIui960c/SM9ayaXR9Q8YPRV93
PVZH94tdMdnO65tsMYmuwMtrN6DOokyT9snS++NHjH7KG2SnGu6lsonLF+Q1oxY4
c+yHZpRcHekTIKU1kuBGq5z/2WvdKq+mmpXOyZMDUDcjta0SsZTWCjbEhvDR69ks
+HleY2okRL+7oIjjwxscikGEU/w60AMl7K+js1sVCImaU/iknNw6zooOqttIQ2D5
TgvMSOhb2J9M4adUWWIjvu34rjzkA29fBJ/ZABEBAAG0HlJhbGYgTGFuZyA8bGFu
Z0BiMS1zeXN0ZW1zLmRlPokBVAQTAQgAPhYhBDyjTDPbiozTL6xj+U/BHU5Zc3Iw
BQJb0s/RAhsDBQkB4TOABQsJCAcCBhUKCQgLAgQWAgMBAh4BAheAAAoJEE/BHU5Z
c3IwGQUH/ity/TiyE0hPR40lAVxRp6DSmiMXj4N1ZNxKpvkZpvrJGFA8N0qmxQlj
uaVbPbZmbY1AUiJ3VrbWMIWq+DGcmghdC4f0ePfRBzQ72S8kzNEnaTbRurxafFIT
nIHQ2m6VSH1V397ItW9f/nmtPQfcsDnJLfyN8wCKRmZtgBRCfCJPIQsWSibL5lML
C0Os2UaHgRRCOcp1da4ETH8UlT5PxLWLKkaQEqY6fwlizAlWLsPT1Wj3CnI0OfAI
HFkt2lv+rpAkmRhhpfuNYm/8LHN/w4OovR7JgVRv+k/HkHj24ghc9+eSCgmu1v/k
3fsO+ozNSNnG3vXKZY+e+LP2oQyEMga5AQ0EW9LP0AEIANHRShH5i8iethpLtwRK
QkFIFQulLwfZgrKdXWdTROB6UT3tDWtojkhKwk9wvR3X2Qck5HTF9ZhuqaaPAxyM
VO8GlkN2OJnE+E7CYuc32E06CUpn9z6oY436qehoq6gAdCXFz8lWJlSuJt6MaHs2
2IomeHmbOPOtRl8RdMzmPyzmFfpQDbOBvOupBUHLYa5Yo1gxsYCB4PDQwJIWvAIh
ASK04Ydins8LvhwHU0PnwaLjHlC6VRkiyrOqsyLZqor/mE1z1yi1HU4DdHtSq13z
HF4R+F0uECuvrpx0KiZFC5UfNeT1f35FS91Yu38Pjq/dKsOJ6XmLtKy6uFOF2KZZ
sC8AEQEAAYkBOwQYAQgAJhYhBDyjTDPbiozTL6xj+U/BHU5Zc3IwBQJb0s/QAhsM
BQkB4TOAAAoJEE/BHU5Zc3IwepEH9jViFWaw4ho2Imo6N6svLalzkDqwpqecR1me
eVncI0W707uB2M4Y4ji9HCxVz5QgAKA4S0GKXUzjKPgbFe2sqI/zM5E6eWiUwcGT
+AA6lvhJb/YKkQ7jZ69CAc09+sV5HFPKMo19Yxpsz45jXhgtlCsCkqcobtEm90Qg
o3HeZ1gJ0VGKxRHakyAsgh5lfKnpIUCRLxmcYpUTCZ0oLhafrwfKlW3X7x0jBC3f
EbYJmGcUBIH7vTxXcmsfh0Ury7JxMjsywsi9AoeVInpO/cCNYYPlsOgO/98hJYGg
kOgZizmcxHWKR+5qM0ufNQoQYU1OhSovkVtNFSn5+lOMiBwtTA==
=oyfV
-----END PGP PUBLIC KEY BLOCK-----

--------------7D4A3F92F15B737C23899937
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-- 
dev mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]

--------------7D4A3F92F15B737C23899937--