[MDEV-16811] CONNECT: TYPE_DATE - Increase Timestamp Range (After 2038) Created: 2018-07-24  Updated: 2018-08-11

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Connect
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Juan Telleria Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None


 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!

 Comments   
Comment by Juan Telleria [ 2018-07-27 ]

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.

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