Colon in time in table

Question

How to convert char type time data into time format of hh:mm when showing in table from database?

I’m using like below code

String sql= select EMPCD,to_char(dat,mm/dd)dat,ontimestr,ontimeend from emp table;

Start time and end time are inserted into table as a char

Answer 1

Why you use CHAR type when you could've used TIME type? is there a benefit of choosing CHAR over TIME?

Answer 2

thank you for your answer.yeah thought came later but i went with manually that i created.so i dont wanna change with that 😅😅 .for temporary i got the solution.i used substr( || ) to get colon in between time of type char.