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

CONNECT: TYPE_DATE - Increase Timestamp Range (After 2038)

    XMLWordPrintable

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

          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.