2 replies to this topic

[mmhairulnizam]

I got problem here ...i want to update data from two table which the field type is difference..anyone plz help me.....

example:

update data birthdate from

table a
-------
birthdate varchar2(8)

to

table b
-------
birthdate date

[WingedPanther]

You'll probably want to use CAST(a.birthdate as date)

[relapse]

What exactly is your problem?