Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13868

cannot insert 1288481126 in a timestamp column in Europe/Moscow

    XMLWordPrintable

Details

    Description

      This used to work in 10.0 and 10.1:

      set time_zone='Europe/Moscow';
      create table t1 (a timestamp);
      set timestamp=1288481126;
      insert t1 values (null);
      select a, unix_timestamp(a) from t1;
      

      but in 10.2 it returns 1288477526 (one hour earlier).

      Because both 1288481126 and 1288477526 are written as 2010-10-31 02:25:26 in time zone Europe/Moscow, and intermediate timestamp→datetime→timestamp conversion loses information.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.