GurcanK
asked on
How to Cast VARCHAR2 to TIMESTAMP(6) In Select Statement In Oracle?
Dear Experts,
I have a table with a field varchar2(24) with values like: '2012-09-27 01:40:31.0' (I think trailing spaces exist as well)
I want to perform insert into table select that field but the corresponding field in the target table is type TIMESTAMP(6)
How can I achieve this?
BR
I have a table with a field varchar2(24) with values like: '2012-09-27 01:40:31.0' (I think trailing spaces exist as well)
I want to perform insert into table select that field but the corresponding field in the target table is type TIMESTAMP(6)
How can I achieve this?
BR
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.