Re: [Discussion] Support Date/Time format for Timestamp columns to be defined at column level

Posted by Lion.X on Oct 29, 2016; 3:00am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Discussion-Support-Date-Time-format-for-Timestamp-columns-to-be-defined-at-column-level-tp1422p2438.html

Hi,all
I have done this issue.
Pls check:
PR 219
https://github.com/apache/incubator-carbondata/pull/219

2016-09-24 16:41 GMT+08:00 向志强 <[hidden email]>:

> Hi, all
>
> In recent days, I am trying to handle issues CARBONDATA-37. We are trying
> to support that Date format can be set at column level.
>
> There is a doubt that we should feedback the the same format for Date
> column or feedback a uniform format. Absolutely.
>
> For example.
>
> we create a table and define two cols which data type is Date. But the
> Date format is different.
>
> col1(Date)       col2(Date)
> 2016-09-24     2016-09-25 00:00:00
>
> when querying, for two formats below, which should be returned?
>
>  col1(Date)       col2(Date)
> 2016-09-24     2016-09-25 00:00:00
>
> or
>
>  col1(Date)                         col2(Date)
> 2016-09-24 00:00:00     2016-09-25 00:00:00
>
> if we set YYYY-MM-DD HH:MM:SS as default format.
>
>
> Best wishes!
>