The X axis display time data although the day col has been casted as a DATE

[mrpbennett]

Hi There

I am having issues with my X Axis displaying a Time based data. I am getting it by hour which is throwing off my graphs

My query is

SELECT
    DATE(day) AS "Day",
    avg_overnight_hrv AS "Overnight HRV",
    resting_heart_rate AS "Resting HR"
FROM
    garmin.sleep
GROUP BY
    1,2,3
ORDER BY
    day;

My table has been created like so

CREATE TABLE garmin.sleep(
    id BIGINT,
    day DATE,
    sleep_time_seconds BIGINT,
    .....
)

The data output is

How ever my graph is like the following:

After checking out some posts on this forum I have added an over ride but it doesn’t seem to work