The following SELECT statements return an error because the source expression does not have a time zone displacement.
SELECT CAST(TIMESTAMP '2008-06-01 08:30:00' AS TIMESTAMP(0) WITH TIME ZONE AT SOURCE TIME ZONE); SELECT CAST(TIMESTAMP '2008-06-01 08:30:00' AS TIMESTAMP(0) WITH TIME ZONE AT SOURCE);