Time to and time from stored as text so can't filter by in Views

I was trying to generate a weekly weather report via Views but found the filter for "Start time" was having no effect.

On further investigation the views query was generating a timestamp but the time_from is stored as text in the database so doesn't work.

Would make sense for time_to and time_from to be stored as dates to allow any meaningful actions.