[
https://issues.apache.org/jira/browse/SPARK-18350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15649858#comment-15649858
]
Xiao Li edited comment on SPARK-18350 at 11/9/16 5:26 AM:
----------------------------------------------------------
Below might be needed if we want to support session timezone?
- Add a SQL statement and API to set the current session timezone?
Link:
https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006728
- Add a SQL statement and API to get the current session timezone?
Link:
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_currenttz.html
- Add time zone specific expressions?
Link:
http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_tzspecificexpression.html
More works are needed if we want to add a new data type {{TIMESTAMP WITH TIME
ZONE}}
Link:
https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1005946
was (Author: smilegator):
Below might be needed if we want to support session timezone?
- Add a SQL statement and API to set the current session timezone?
Link:
https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1006728
- Add a SQL statement and API to get the current session timezone?
Link:
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_currenttz.html
- Add time zone specific expressions?
Link:
http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_tzspecificexpression.html
More works are needed if we want to add a new data type {TIMESTAMP WITH TIME
ZONE}
Link:
https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#i1005946
> Support session local timezone
> ------------------------------
>
> Key: SPARK-18350
> URL: https://issues.apache.org/jira/browse/SPARK-18350
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Reporter: Reynold Xin
>
> As of Spark 2.1, Spark SQL assumes the machine timezone for datetime
> manipulation, which is bad if users are not in the same timezones as the
> machines, or if different users have different timezones.
> We should introduce a session local timezone setting that is used for
> execution.
> An explicit non-goal is locale handling.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
