How we can use timestamp with timezone in teradata(Eqv to from_tz in oracle)

UDA
Junior Contributor

Re: How we can use timestamp with timezone in teradata(Eqv to from_tz in oracle)

Why don't you simply try it?

 

SELECT TIMESTAMP '2016-11-06 05:59:00+00:00' AT 'america eastern',
       TIMESTAMP '2016-11-06 06:01:00+00:00' AT 'america eastern'

2016-11-06 01:59:00-04:00 
2016-11-06 01:01:00-05:00