I have a query that outputs the hour of a timestamp as a integer. Is a possible to have metabase recognize this as an hour instead of as an int? For example I want “13” to be recognized as 1pm and so on. I am grabbing the hour with the below.
extract(hour from completed_at)