[#MDEV-21268] UNIX_TIMESTAMP(arg) subtracts from arg difference between UTC and local time

[MDEV-21268] UNIX_TIMESTAMP(arg) subtracts from arg difference between UTC and local time Created: 2019-12-10 Updated: 2020-02-14 Resolved: 2020-02-14
Status:	Closed
Project:	MariaDB Server
Component/s:	OTHER
Affects Version/s:	10.4.6
Fix Version/s:	N/A

Type:

Bug

Priority:

Major

Reporter:

Alexander Matyushkin

Assignee:

Unassigned

Resolution:

Incomplete

Votes:

Labels:

need_feedback

Environment:

Windows 7

Description

UNIX_TIMESTAMP(arg) subtracts from arg difference between UTC and local time, but arg is UTC from the beginning

Comments

Comment by Elena Stepanova [ 2020-01-13 ]

Could you please provide an actual example of a function call and wrong result vs expected result?
Please also include show variables like '%time_zone%' into the same example.

Generated at Thu Feb 08 09:05:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-21268] UNIX_TIMESTAMP(arg) subtracts from arg difference between UTC and local time Created: 2019-12-10 Updated: 2020-02-14 Resolved: 2020-02-14