Query to display whole data upto the previous day.

select XXXXX, SSSSSSSS, DDDDDD , CAST(date(h_date) as CHAR) as h_date from TABLENAME where h_date < (CURDATE()) order by h_date desc  ";

ie., If the current date is 22-08-2016 , It will display data upto 21-08-2016 .
Example:
+--------------+
| h_date |
+--------------+
| 2016-07-27   |
| 2016-07-27   |
| 2016-07-23   |
| 2016-07-20   |
| 2016-07-18   |
| 2016-07-15   |
| 2016-07-13   |
| 2016-07-13   |
| 2016-07-12   |
| 2016-07-10   |
+--------------+