You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2019/03/26 18:34:31 UTC
[GitHub] [spark] dilipbiswal commented on issue #24195: [SPARK-25496][SQL]
Deprecate from_utc_timestamp and to_utc_timestamp
dilipbiswal commented on issue #24195: [SPARK-25496][SQL] Deprecate from_utc_timestamp and to_utc_timestamp
URL: https://github.com/apache/spark/pull/24195#issuecomment-476789893
@cloud-fan @MaxGekk Sorry if my question is dumb as i don't know the inner workings of the timestamp type. I know that these functions are used frequently. I just looked at this page [link](https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0061916.html). For all the three examples in that page, our result seems to match the expected result ?
```
spark-sql> values from_utc_timestamp('2011-12-25 09:00:00.123456', 'Asia/Tokyo');
2011-12-25 18:00:00.123456
Time taken: 2.289 seconds, Fetched 1 row(s)
spark-sql> values from_utc_timestamp('2014-11-02 06:55:00', 'America/Toronto');
2014-11-02 01:55:00
Time taken: 0.031 seconds, Fetched 1 row(s)
spark-sql> values from_utc_timestamp('2015-03-02 06:05:00', 'America/Toronto');
2015-03-02 01:05:00
Time taken: 0.029 seconds, Fetched 1 row(s)
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org