How to convert from CHAR to TIME to postgresql
I have a table with a column defined as time CHAR(6)
with values such as '18:00'
that I need to convert from char
to time
.
I searched here but failed.
+3
Joanisc
source
to share
3 answers
The syntax ::
can be used to create a value:
SELECT my_column::time
FROM my_table
+2
Mureinik
source
to share
If the value is indeed a valid time, you can simply specify it:
select '18:00'::time
0
a_horse_with_no_name
source
to share
As said, you can use :: to cast, but you can also use the standard CAST () function:
SELECT CAST(my_column AS time) AS my_column_time
FROM my_table;
This also works on other databases, not just PostgreSQL.
0
Frank heikens
source
to share