// Alter the table to change the data type of the 'date' column ALTER TABLE amazon_sales_raw ALTER COLUMN date TYPE DATE USING TO_DATE(date, 'MM/DD/YY');