1 -- @tag: letter_date_type
2 -- @description: Briefe: Datumsfeld als Datum speichern
3 -- @depends: release_3_2_0 letter
5 ALTER TABLE letter ADD column date_date DATE;
6 UPDATE letter SET date_date = date::DATE;
7 ALTER TABLE letter DROP COLUMN date;
8 ALTER TABLE letter RENAME COLUMN date_date TO date;