DQL Query - Date format different in preview and view mode

DQL Query - Date format different in preview and view mode

Hello,

I have the following SQL query:
SELECT Max("Date"), "Person", "Name", SUM("Pcs") '# of Pcs' , SUM("Hours") 'Hours', ((SUM("Pcs")/SUM("Hours"))/60) 'Pcs/min', Sum ("Scrap") Scrap FROM "BCoil Report" where DATEDIFF(CURRENT_DATE(), "Date")<=60 group by "Person", "BCoil Name"

In preview mode, I am able to see the date in the format "yyyy-mm-dd 00:00:00".
However in "view mode" it converts it to what I think is text. E.x "[B@6803f59b"
How do I fix this?

As well, any suggestions on how would I change the format to be just "dd-mm-yy"?

Thanks,
Nish