[
https://issues.apache.org/jira/browse/DRILL-7989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17410172#comment-17410172
]
ASF GitHub Bot commented on DRILL-7989:
---------------------------------------
luocooong commented on pull request #2299:
URL: https://github.com/apache/drill/pull/2299#issuecomment-913158816
@paul-rogers Thanks for the information. YES, the time-zone is always GMT+8.
The good thing is, I have pushed a new revision patch. The issue is that there
was an error in the time conversion.
[UtcTimestampValueListener](https://github.com/apache/drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/store/easy/json/values/UtcTimestampValueListener.java)
is a good solution.
```
// query text
select `date`, AGE(`date`, CAST('2019-09-30 20:47:43' as timestamp)) from ...
// output
date<TIMESTAMP(OPTIONAL)> EXPR$1<INTERVAL(OPTIONAL)>
2019-10-01T04:47:43.123 PT28800.123S
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
> Use the UTC formatter in the JSON reader
> ----------------------------------------
>
> Key: DRILL-7989
> URL: https://issues.apache.org/jira/browse/DRILL-7989
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Cong Luo
> Assignee: Cong Luo
> Priority: Major
> Fix For: 1.20.0
>
>
> MongoDB use the UTC format to specify the date value by default. But the JSON
> reader (old version) use the fixed date formatter :
> "yyyy-MM-dd'T'HH:mm:ss.SSSXX". Need to change to the
> "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" format.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
