[FEA] Support to_utc_timestamp for US/Central timezone

[viadea]

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 #6839

[revans2]

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 #6840 or perhaps some very simple follow on work for it.

[viadea]

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