将数据从列插入另一个不同的表列，并在PSQL中进行修改

I have a table called log that contains a column called time which is a time stamp with time zone, I wanna remove the time and only leave the date then put the modifying result in another column called day in a table called error. For example if the the I have a table called log that contains a colum