spark-rapids icon indicating copy to clipboard operation
spark-rapids copied to clipboard

[FEA] Support to_utc_timestamp for US/Central timezone

Open viadea opened this issue 1 year ago • 1 comments

Is your feature request related to a problem? Please describe. I wish we can support to_utc_timestamp for US/Central timezone.

Such as

to_utc_timestamp(tz, 'US/Central')

This might be a sub-task of https://github.com/NVIDIA/spark-rapids/issues/6839

viadea avatar Oct 21 '24 16:10 viadea

The hard part is that 'US/Central' has time zones transitions in it. But that is all that to_utc_timestamp does. Is it transitions a timestamp from one timezone to UTC. So this is really a sub-task of https://github.com/NVIDIA/spark-rapids/issues/6840 or perhaps some very simple follow on work for it.

revans2 avatar Oct 21 '24 19:10 revans2

I wish we can expand the scope of this feature request to support all major US timezones: CST, EST, PST.

I can open a new feature request for from_utc_timestamp as well

viadea avatar Jan 24 '25 17:01 viadea

Closed by #12502. test_comprehensive_to_utc_timestamp checks that it works with all timezones.

warrickhe avatar May 09 '25 18:05 warrickhe