'Smart Date' shows inconsistent date formats on 1st of month

[dugjason]

On September 1st, I checked a chart which contained data from August 30, 31 and Sept 1. The timestamps shown for each column are;

• Tue Aug 30
• Wed Aug 31
• September 2016

It would make sense to me to show "Thu Sep 01" for consistency

SQL query and response were;

SELECT subtype AS subtype,
       DATE(created_at) AS timestamp,
       COUNT(*) AS count
FROM fb_ms_staging
INNER JOIN
  (SELECT subtype AS subtype__
   FROM fb_ms_staging
   WHERE created_at >= '2016-08-25 09:17:04.000000'
     AND created_at <= '2016-09-01 09:17:04.000000'
   GROUP BY subtype
   ORDER BY COUNT(*) DESC LIMIT 50) AS anon_1 ON subtype = subtype__
WHERE created_at >= '2016-08-25 09:17:04.000000'
  AND created_at <= '2016-09-01 09:17:04.000000'
GROUP BY subtype,
         DATE(created_at)
ORDER BY count DESC LIMIT 50000

+---------+------------+-------+
| subtype | timestamp  | count |
+---------+------------+-------+
| link    | 2016-08-31 |    64 |
| link    | 2016-08-30 |    39 |
| photo   | 2016-08-30 |    15 |
| link    | 2016-09-01 |    12 |
| photo   | 2016-08-31 |     7 |
| status  | 2016-08-31 |     4 |
| video   | 2016-08-31 |     4 |
+---------+------------+-------+
7 rows in set (0.86 sec)

Using Caravel 0.10.0 (from pip install) on OSX

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.