Cannot Coerce value into type

I have a date in mysql, i have a query that pulls the date onto the screen to be displayed. The date in the database "2023-02-03 10:10:10" gets displayed in epoch time when queried "121234124144124124"

When i try to run a transform or expression to convert the epoch to a date i get the error in the title. I can script something to fix it but i figured I could do this out of the box.

Anyone have any suggestions? Thanks

I'm not familiar with maker edition, but I remember encountering a similar problem in Perspective a little while back, and this was the solution:

Thanks, I just ended up using a scalar query and it worked fine with a format binding. The issue was that it was returning a dataset. thanks though