If the only reason to select that date back is to use it later in the insert statement, then you really don't need to do that. If the type of FT_DATE column is Date, you can simply use to_date in the values clause of that insert statement.