如果源是 DECIMAL yyyymmdd 你可以这样做

If source is a DECIMAL yyyymmdd you can do

CAST(invitation_date - 19000000 AS DATE) AS newcol

Teradata 允许在任何地方使用别名，因此您只需执行

Teradata allows an alias to be used in any place, so you can simply do

WHERE newcol > DATE

当然***的情况是在加载期间将这些列更改为 DATE.

Of course best case would be to change those columns to DATE during load.