clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601562 fiddles created (47968 in the last week).

create table sales (ID int, yourdate varchar(32))
 hidden batch(es)


insert into sales values (1, 'November 5, 2019 12:46:03 AM')
 hidden batch(es)


insert into sales values (2, 'November 30, 2019 12:46:03 AM')
 hidden batch(es)


insert into sales values (3, 'November 10, 2019 12:46:03 AM')
 hidden batch(es)


insert into sales values (4, 'November 3, 2019 12:46:03 AM')
 hidden batch(es)


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
 hidden batch(es)


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