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]
