Simple Casting or Date Formatting Question

I have an SQL query that returns values averaged by day. I want to plot them on a chart to show the trend.

My values come from a transaction group, so they are saved with a time stamp that I CAST as Date.

When the values are summarized by day, the x-axis date I get back is like Aug 27, 2020 12:00 AM.

My chart ends up with hours of the day on it, but I want just the day.

I can get the format looking right by using CONVERT, but then the chart chokes on it because it wants a time instead of a string.

Is there something I can do to just get the date returned when I cast as date, or should I convert to string and then change my chart to treat the dates like categories? Or is there something else I’m missing here?

Thank you.

I typically return the day as a number in the query and then use that.
Just simplifies things.

I’m not sure I understand what you mean. As a number in date format or as an integer?

Sorry yes as an integer.
MS SQL
SELECT DATEPART("d",MyDateField) as DayNum
Then use DayNum as the axis value.

That makes perfect sense.

Thank you!