15.00 - 9257 AT clause may only occur after DATE, TIME, or TIMESTAMP and must not occur before WITH TIME ZONE. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9257 AT clause may only occur after DATE, TIME, or TIMESTAMP and must not occur before WITH TIME ZONE.

Explanation:

An AT clause may only occur after the target data type in a CAST or Teradata conversion (other data attributes may occur between the target data type and the AT clause). In addition, WITH TIME ZONE must not be specified after an AT clause (it may be specified after the target data type but before the AT clause). The target date type must be DATE, TIME, or TIMESTAMP.

Generated By:

SYN modules.

For Whom:

End user.

Remedy:

Correct the request and resubmit it.