TIMESTAMP(6) WITH TIME ZONE, space between seconds and timezone, need to remove it

Database
Teradata Employee

Re: TIMESTAMP(6) WITH TIME ZONE, space between seconds and timezone, need to remove it

Teradata does not recognize the Z suffix in your literal as denoting GMT / UTC. (Try it without the "AT" clause and you will see.)

Format of a "timestamp with time zone" literal would be '2017-07-31 20:08:54.810+00:00'