MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table sales (ID int,  yourdate varchar(32))
insert into sales values (1, 'November 5, 2019 12:46:03 AM')
insert into sales values (2, 'November 30, 2019 12:46:03 AM')
insert into sales values (3, 'November 10, 2019 12:46:03 AM')
insert into sales values (4, 'November 3, 2019 12:46:03 AM')
SELECT* FROm sales WHERE STR_TO_DATE(yourdate,"%M %e, %Y %h:%i:%s %p") < NOW() - INTERVAL 6 DAY


ID
yourdate


1
November 5, 2019 12:46:03 AM

2
November 30, 2019 12:46:03 AM

3
November 10, 2019 12:46:03 AM

4
November 3, 2019 12:46:03 AM


SELECT DATE_FORMAT("5, 2019","%e, %Y");
# %h:%i:%s %p    November 12:46:03 AM


DATE_FORMAT("5, 2019","%e, %Y")


null

ID	yourdate
1	November 5, 2019 12:46:03 AM
2	November 30, 2019 12:46:03 AM
3	November 10, 2019 12:46:03 AM
4	November 3, 2019 12:46:03 AM