[MCOL-796] Datetime should support 'd-mm-yyyy' Created: 2017-07-02  Updated: 2017-07-02  Resolved: 2017-07-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: cpimport
Affects Version/s: 1.0.8, 1.0.9
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: james mclaurin (Inactive) Assignee: Andrew Hutchings (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS

Issue Links:
Duplicate
duplicates MCOL-502 Add a command line parameter for cpim... Closed

 Description   

cpimport produces error on datetime field in format of '07-01-2016 9:34'

I think ColumnStore should support 'd-m-y' format

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2017-07-02 ]

Without specifying a date format it would be impossible to know in advance whether that particular date coming in was US or UK format. This is why databases typically use the international standard of ISO8601 for date/time formats. We have Jira MCOL-502 as a feature request for specifying date formats and we are currently working on tools that will allow this to happen.

I'll mark this as a duplicate of MCOL-502.

Generated at Thu Feb 08 02:23:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.