You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2019/12/05 23:00:01 UTC
[jira] [Commented] (IMPALA-8704) SQL:2016 datetime patterns -
Milestone 2
[ https://issues.apache.org/jira/browse/IMPALA-8704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16989232#comment-16989232 ]
ASF subversion and git services commented on IMPALA-8704:
---------------------------------------------------------
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 2
> ----------------------------------------
>
> Key: IMPALA-8704
> URL: https://issues.apache.org/jira/browse/IMPALA-8704
> 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 2 content:
> - Nested strings
> - FM/FX modifiers
--
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