Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I want to update timestamp(3) column with respect to varchar2

849776Apr 12 2011 — edited Apr 12 2011
Hi all,

I have a date field column with varchar2 as datatype :
create table t1 (id number,date1 varchar2(35))

insert into (1,' 3/13/2011 10:22 AM');

insert into (2,' 3/14/2011 10:22 AM');
insert into (3,' 3/15/2011 10:22 AM');


I want to update table2 

create table t1 (id number,date1 timestamp(3))

insert into (1,' ');

insert into (2,' ');
insert into (3,' ');
I want to update t2 with date column in t1
can any one help me

Thanks in advance!!!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2011
Added on Apr 12 2011
4 comments
3,139 views