[
https://issues.apache.org/jira/browse/DRILL-7926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17383031#comment-17383031
]
ASF GitHub Bot commented on DRILL-7926:
---------------------------------------
oleg-zinovev edited a comment on pull request #2268:
URL: https://github.com/apache/drill/pull/2268#issuecomment-882272366
@paul-rogers
I would like to clarify the use of the user's timezone.
1) Functions to convert time stamp from string and back use UTC time zone
2) TimeStampAccessor uses UTC timezone
3) QueryContextInformation#queryStartTime is filled with value obtained from
System#currentTimeMillis.
This method returns a timestamp in UTC timezone (aka UNIX timestamp)
(https://docs.oracle.com/javase/7/docs/api/java/lang/System.html#currentTimeMillis())
What timezone should I use in the age function?
--
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]
> The " age " function is not working properly.
> ---------------------------------------------
>
> Key: DRILL-7926
> URL: https://issues.apache.org/jira/browse/DRILL-7926
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.17.0, 1.18.0
> Reporter: Александр Глухов
> Priority: Blocker
> Attachments: image-2021-05-13-16-17-21-154.png, screenshot-1.png,
> screenshot-2.png
>
>
> The " age " function is not working properly.
> *Playback steps*
> {code:sql}
> select extract(year from m. "years") `years` from (select age('2021-05-13',
> '2007-07-02') `years") m{code}
> *Expected result* 13.
> *Actual result* 14.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
