0 - 2 of 2 tags for create table - date issue

I'm facing a pretty strange issue here, wanted to see if anybody had any insight on this. 
I'm creating a TD table with a TIME(0) field in it. Strangely, once the CREATE TABLE is complete, the table is created with a INTEGER field instead.
Table Create SQL:

Hi, I have a simple SQL where I am trying to create a table using a select statement, I have no idea why this is bumping me out. The select by itself is working and returning rows successfully. Please help.

This is the SQL -

create table dbc.tb2 as
substr(compltn_dt,1,position(' ' in compltn_dt )) as dt,
trim(substr(compltn_dt,position(' ' in compltn_dt )+1,characters(compltn_dt)))as ts,
Trim(case when position ('/' in dt) = 2 then 0||substring(dt,1,1) else substr(dt,1,2) end) as mth,