Re^3: copying mysql table data to oracle table

You might want the timestamp datatype instead

Comment on Re^3: copying mysql table data to oracle table

Replies are listed 'Best First'.
Re^4: copying mysql table data to oracle table by CSharma (Sexton) on Aug 25, 2017 at 07:52 UTC
Thanks for all help! I just got this fixed by setting as below: `my $date_conv = $odbh->prepare("ALTER SESSION SET NLS_DATE_FORMAT = 'Y +YYY-MM-DD HH24:MI:SS'"); $date_conv->execute;` [download]	[reply] [d/l]