Query run successfully in PostgreSQL but return error in Grafana dashboard


I tried to create a dashboard contains list of ticket creation based on hour, I used below function in my code:

date_trunc(‘hour’, creationtime::time) AS time

Somehow it can only be run in PostgreSQL, in Grafana it returns with error “converting time columns failed: failed to convert time column: column type “*string” is not convertible to time.Time”

Please help me, thank you so much!

Welcome @ntak1810

Have you tried a transformaton like this to convert the field type from string to time?