PostgreSQL-错误 : column "date" cannot be cast to type date

Question

我想将我的 PostgreSQL 数据库中的特定列从 character_varying 类型转换为类型日期。phpPgAdmin 给我以下错误:

ERROR: column "date" cannot be cast to type date

In Statement: ALTER TABLE "public"."tablename" ALTER COLUMN "date" TYPE date

我该怎么办？谢谢

Answer 1

您可能需要先将其转换为文本:

alter table "foo" alter column "date" type date using ("date"::text::date);