We're updating the issue view to help you get more done. 

FROM_UNIXTIME same date time from two different timestamp

Description

I am having a weird problem with mariadb. I am using FROM_UNIXTIME to convert timestamp to datetime. The problem is two different timestamp is resulting to same datetime. How can it be possible?

Here what I got from mariadb-

1 SELECT from_unixtime( '1456017720' ) , from_unixtime( '1456021320' )

Output on my timezone-

1 2016-02-20 23:22:00 2016-02-20 23:22:00

Another example:

1 SELECT from_unixtime( '1456016700' ) , from_unixtime( '1456020300' )

Output on my timezone-

1 2016-02-20 23:05:00 2016-02-20 23:05:00

This is wrong because no two different timestamp should return same date time.

I have attached screenshot proof of output that I got via phpmyadmin.

Version info-

1 2 3 4 5 6 7 innodb_version 5.6.26-76.0 protocol_version 10 slave_type_conversions version 10.0.23-MariaDB version_comment MariaDB Server version_compile_machine x86_64 version_compile_os Linux version_malloc_library bundled jemalloc

Environment

CentOS 64 bit

Status

Assignee

Sergei Golubchik

Reporter

Enne Fayen

Labels

None

External issue ID

None

External issue ID

None

Components

Fix versions

Affects versions

10.0.23-galera

Priority

Major