I have a source table with column named "created_time" whose data type is varchar(22). I need to migrate timestamp value of this column to target table in DB2 whose datatype is TIME. I tried different db2 timestamp and date related function but that's not working for me. Is there anyway I can directly convert it into the desired format?
Source Field Value : 7/1/2013 6:18:59 PM Target Field Value : 06:18:59
I tried below statement as a starter
SELECT date(to_date(created_time,'DD-MM-YYYY HH:MI:SS')) FROM table