Search code examples
postgresqldatealter-tabletimestamp-with-timezone

Change column date with time zone

Short question! I have a column with a date (timestamp with time zone) and it looks like f.e.: "1993-11-22 12:00:00+01"

I want to change the content of this column so that in the end I have: "1993-11-22"

How can this easily be done?

Thanks!!

Solution

  • Change the data type to be a date:

    alter table TABLE alter COLUMN type date;