'how to convert data/time data into integer to use the histogram widget at carto?

I want to use the histogram widget at carto builder as time-series widget doesn't have that level of granularity. I have date and time data but how can I convert it into numbers as the histogram widget only allows number format(I guess..). For example, 11:15:00 into 11.15 and 15:30 into 15.30?

enter image description here

sqldatetimeintegerhistogram


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions