How do I convert string to time in postgresql?

Question

I have a column of type varchar with a time on it like 120217. I would like to convert this to a time format I can query. Would something like

alter table public.table alter column col_time type date using to_date(col_time, 'HHMMSS');

work?

Answer 1

this should do:

alter table public.table 
alter column col_time 
type time using (col_time::time);