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

CONNECT: TYPE_DATE - Increase Timestamp Range (After 2038)

Details

    Description

      Currently, Connect TYPE_DATE only handles dates from 13 December 1901, 20:45:52 to 18 January 2038, 19:14:07 (As appears in MariaDB Knowledge Base Docs).

      In order to increase this DATE Range:

      • OPTION A: Create a my.ini options for CONNECT Engine that allow to move this Time Frame? For example, add in my.ini:
        • connect_type_date_start = 1970-01-01
      • OPTION B: Make TYPE_DATE and 8 bytes integer.
      • OPTION C: Or consider DATE columns as characters (Internally), and perform a conversion from CHAR to DATETIME at the end.

      And with CONNECT ODBC Table Type and Date Range the behavior is not well documented, ¿Does previous behavior also apply?

      Thanks!

      Attachments

        Activity

          Juan Juan Telleria added a comment - - edited

          bertrandop The whole point of this Issue is that only 20 years are left for January 2038, and therefore, we are starting to have some Dates which are assigned NULL instead of their value.

          Juan Juan Telleria added a comment - - edited bertrandop The whole point of this Issue is that only 20 years are left for January 2038, and therefore, we are starting to have some Dates which are assigned NULL instead of their value.

          People

            Unassigned Unassigned
            Juan Juan Telleria
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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