Reston Multiplex Cinemas Movie Showtimes

Nov 18,  · A DATE column always has year, month, day, hour, minute and second components so converting to a DATE is not going to eliminate those time components (but will discard the fractional seconds stored in the TIMESTAMP).. Add the new column: ALTER TABLE table_name ADD new_date_column DATE; Then use an implicit cast: UPDATE table_name .