[jira] [Created] (DRILL-2389) The hour number extracted from current_timestamp is wrong

["Chun Chang (JIRA)" <ji...@apache.org>]

Chun Chang created DRILL-2389:
---------------------------------

             Summary: 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: Daniel Barclay (Drill)
            Priority: Critical


#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)