[jira] [Commented] (IMPALA-8705) SQL:2016 datetime patterns - Milestone 3

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-8705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16989230#comment-16989230 ] 

ASF subversion and git services commented on IMPALA-8705:
---------------------------------------------------------

Commit 30c7a6a18c85574ff76dc750dfef94475f1c9796 in impala's branch refs/heads/master from Gabor Kaszab
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=30c7a6a ]

IMPALA-8705: ISO:SQL:2016 datetime patterns - Milestone 3

This patch adds additional datetime format tokens on top of
Milestone 1 (IMPALA-8703) and Milestone 2 (IMPALA-8704).

The tokens introduced:
- Full month name (MONTH, Month, month): In a string to datetime
  conversion this token can parse textual month name into a datetime
  type. In a datetime to string conversion this token gives the
  textual representation of a month.
- Short month name (MON, Mon, mon): Similar to the full month name
  token but this works for 3-character month names like 'JAN'.
- Full day name (DAY, Day, day): In a datetime to string conversion
  this token gives the textual representation of a day like
  'Tuesday.' Not suppported in a string to datetime conversion.
- Short day name (DY, Dy, dy): Similar to full day name token but
  this works for 3-character day names like 'TUE'. Not suppported in
  a string to datetime conversion.
- Day of week (D): In a datetime to string conversion this gives a
  number in [1-7] where 1 represents Sunday. Not supported in a
  string to datetime conversion.
- Quarter of year (Q): In a datetime to string conversion this gives
  a number in [1-4] representing a quarter of the year. Not supported
  in a string to datetime conversion.
- Week of year (WW): In a datetime to string conversion this gives a
  number in [1-53] to represent the week of year where the first week
  starts from 1st of January. Not supported in a string to datetime
  conversion.
- Week of month (W): In a datetime to string conversion this gives a
  number in [1-5] to represent the week of month where the first week
  starts from the first day of the month. Not supported in a string
  to datetime conversion.

Change-Id: Ic797f19a1311b54e5d00d01d0a7afe1f0f21fb8f
Reviewed-on: http://gerrit.cloudera.org:8080/14714
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>


> SQL:2016 datetime patterns - Milestone 3
> ----------------------------------------
>
>                 Key: IMPALA-8705
>                 URL: https://issues.apache.org/jira/browse/IMPALA-8705
>             Project: IMPALA
>          Issue Type: Sub-task
>          Components: Backend
>    Affects Versions: Impala 2.2.4
>            Reporter: Gabor Kaszab
>            Assignee: Gabor Kaszab
>            Priority: Major
>              Labels: ramp-up
>             Fix For: Impala 3.4.0
>
>
> Design doc for SQL:2016 datetime patterns:
> https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/
> Milestone 3 content:
> - Tokens for month name (MONTH, MON, Month etc.)
> - Day of week token (D)
> - Tokens for day name (DAY, DY, Day etc.)
> - Quarter of year token (Q)
> - Week of year token (WW)
> - Week of month token (W)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org