Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
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!