02-10-2020 10:53 AM
That seems strange,
Have you tried the reverse, convert the date you want to compare to a string, and then compare
select * from table where (your column cast to string) = date_format(date_sub(current_date(),1), 'yyyyMMdd')
