[
https://issues.apache.org/jira/browse/DRILL-2389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14357291#comment-14357291
]
Mehant Baid commented on DRILL-2389:
------------------------------------
Functions like current_timestamp, now, timestamptztype return timestamp with
time zone however for 1.0 we aren't planning to support timestamp with time
zone so using this JIRA to remove some of the existing logic. For commonly used
functions like current_timestamp and now, will be aliasing those to functions
that return only timestamp.
> The hour number extracted from current_timestamp is wrong
> ---------------------------------------------------------
>
> Key: DRILL-2389
> URL: https://issues.apache.org/jira/browse/DRILL-2389
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 0.8.0
> Reporter: Chun Chang
> Assignee: Mehant Baid
> Priority: Critical
> Fix For: 0.9.0
>
>
> #Wed Mar 04 01:23:42 EST 2015
> git.commit.id.abbrev=71b6bfe
> Note, the hour number extracted from current_timestamp is changed from 15 to
> 23.
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select current_timestamp,
> extract(year from current_timestamp) yr, extract(month from
> current_timestamp) m, extract(day from current_timestamp) d, extract(hour
> from current_timestamp) h, extract(minute from current_timestamp) minu,
> extract(second from current_timestamp) s from sys.drillbits;
> +-------------------+------------+------------+------------+------------+------------+------------+
> | current_timestamp | yr | m | d | h |
> minu | s |
> +-------------------+------------+------------+------------+------------+------------+------------+
> | 2015-03-04 15:48:27.334 | 2015 | 3 | 4 | 23
> | 48 | 27.334 |
> | 2015-03-04 15:48:27.334 | 2015 | 3 | 4 | 23
> | 48 | 27.334 |
> | 2015-03-04 15:48:27.334 | 2015 | 3 | 4 | 23
> | 48 | 27.334 |
> | 2015-03-04 15:48:27.334 | 2015 | 3 | 4 | 23
> | 48 | 27.334 |
> +-------------------+------------+------------+------------+------------+------------+------------+
> 4 rows selected (0.07 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
