Home » SQL & PL/SQL » SQL & PL/SQL » Re: Need help with to_date() function, thanks!
Re: Need help with to_date() function, thanks! [message #36230] Mon, 12 November 2001 09:48
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Is there any reason why you need the cursor??

insert into tab2(col1, new_date_col) select col1, to_date(old_date_col, 'dd-mm-yyyy') -- or whatver format
from tab1;

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Need help with to_date() function, thanks!
Next Topic: Fire triggers on time events
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 14:54:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.