// 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');