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)
Hi @madkap
Currently not, since when you’re querying via the interface (QB), it also just returns an integer, but the difference between QB and SQL is that Metabase doesn’t know the column type in SQL.
You would have to convert it to a string. I don’t know what database you’re querying, but maybe you should try DATE_FORMAT()