drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-758) to_timestamp(unix time) not returning correct result
Date Fri, 16 May 2014 15:15:15 GMT
Krystal created DRILL-758:
-----------------------------

             Summary: to_timestamp(unix time) not returning correct result
                 Key: DRILL-758
                 URL: https://issues.apache.org/jira/browse/DRILL-758
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Krystal


Ran the following to_timestamp query passing it a unix timestamp:

select to_timestamp(1284352323) from voter where voter_id=10;

The value returned looks like unix epoch time:
 1970-01-15T20:45:52.323-08:00

Any unix time used returned the same year (1970) and month (01).



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message