15.00 - 6972 WITH DEFAULT is not allowed on a PERIOD(TIME) column. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

6972 WITH DEFAULT is not allowed on a PERIOD(TIME) column.

Explanation:

The WITH DEFAULT option is not allowed on a PERIOD(TIME) column. The default value for a PERIOD(TIME) column can be set using a Period value constructor or a Period literal.

Generated By:

Parser.

For Whom:

End User.

Remedy:

Rewrite the statement without using WITH DEFAULT on PERIOD(TIME).