[#MDEV-16422] DST and unix

[MDEV-16422] DST and unix_timestamp(now()) Created: 2018-06-07 Updated: 2023-09-24
Status:	Confirmed
Project:	MariaDB Server
Component/s:	Temporal Types, Time zones
Affects Version/s:	10.1, 10.2, 10.3, 10.4
Fix Version/s:	10.6

Type:

Bug

Priority:

Major

Reporter:

Sergei Golubchik

Assignee:

Alexander Barkov

Resolution:

Unresolved

Votes:

Labels:

None

Issue Links:

Blocks
blocks	MDEV-16423	DST and timestamp comparison	Confirmed
Duplicate
is duplicated by	MDEV-16013	During the extra hour upon DST switch...	Stalled
Relates
relates to	MDEV-22828	Bad results near DST change: UNIX_TIM...	Open
relates to	~~MDEV-32148~~	Inefficient WHERE timestamp_column=da...	Closed
relates to	MDEV-32152	Wrong results near DST for `WHERE ind...	Open

Description

set time_zone='Europe/Moscow';

set @@timestamp=1067122861;

select @@timestamp, unix_timestamp(now(6));

Returns:

@@timestamp     unix_timestamp(now(6))

1067122861.000000       1067119261.000000

Generated at Thu Feb 08 08:28:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.