Implicit conversion of mysql TIMESTAMP type to Horde_Date

Ralf Lang <[email protected]> Mon, 7 Jan 2019 16:25:53 +0100
Newsgroups gmane.comp.horde.devel
Message-ID <[email protected]>
This is a multi-part message in MIME format.
--------------58712DB6DC6AB11532F1B51A
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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?



--------------58712DB6DC6AB11532F1B51A
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-----

--------------58712DB6DC6AB11532F1B51A
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]

--------------58712DB6DC6AB11532F1B51A--