[
https://issues.apache.org/jira/browse/DRILL-3971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15002891#comment-15002891
]
Kristine Hahn commented on DRILL-3971:
--------------------------------------
This timestamp info was added a while ago. Please review:
http://drill.apache.org/docs/data-type-conversion/#to_date
> to_date(timestamp) is supported
> --------------------------------
>
> Key: DRILL-3971
> URL: https://issues.apache.org/jira/browse/DRILL-3971
> Project: Apache Drill
> Issue Type: Task
> Components: Documentation
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Kristine Hahn
>
> Do a search for "to_date" in this link:
> https://drill.apache.org/docs/data-type-conversion/
> We would find that it says these two are supported:
> 1. expression is a character string enclosed... (rest is omitted)
> 2. 'format' is a format specifier enclosed... (rest is omitted)
> Due to DRILL-3769, let's add one more supported case: expression can be
> timp_stamp type.
> A example would be:
> {code}
> 0: jdbc:drill:zk=local> select to_date(to_timestamp(1000000000)) from
> (VALUES(1));
> +-------------+
> | EXPR$0 |
> +-------------+
> | 2001-09-09 |
> +-------------+
> {code}
> Note that to_timestamp(1000000000) would generate a timestamp with value
> 2001-09-08 18:46:40.0 (on MAC, which can be different on Linux )
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
