Update data types of TABLE SO_SALE in your database making SaleDate as DATE and Sale Price as Number Step 1 Set data in the correct format (update, use substr() and str_to_date().replace() ) Step 2 Alter table. SaleDate Sale Price "Wed May 21 00:00:00 EDT 2008" "59222" "Wed May 21 00:00:00 EDT 2008" "68212" "Wed May 21 00:00:00 EDT 2008" "68880" "Wed May 21 00:00:00 EDT 2008" "69307" "Wed May 21 00:00:00 EDT 2008" "81900" "Wed May 21 00:00:00 EDT 2008" "89921" "Wed May 21 00:00:00 EDT 2008" "90895" "Wed May 21 00:00:00 EDT 2008" "91002" "Wed May 21 00:00:00 EDT 2008" "94905" "Wed May 21 00:00:00 EDT 2008" "98937