How to solve postgresql ERROR: cannot cast type time without timezone to date
i get this error on postgresql :
ERROR: cannot cast type time without timezone to date
LINE 1: ... COLUMN tgl_disetujui TYPE date USING (tgl_disetujui:date);
-----
run this query to solve :
1) ALTER TABLE table_name ALTER COLUMN field_name TYPE timestamp with time time zone USING current_date + field_name;
2) ALTER TABLE table_name ALTER COLUMN field_name TYPE date USING (field_name::date);
see this video for details :)