Iam readign CSV file using squential stage , input data from that it coming like 1-Apr-95 , 1-sep-00 how to Load that into Oracle DB
I have tried stringtodate(input,"%dd-%mmm-%yy") But it is working only for data like
27-sep-95 not for 1-Apr-07 , how to overcome this Issue.
Thanks
Hasan
File input "1-Apr-97" how to convert in date
Moderators: chulett, rschirm, roy
File input "1-Apr-97" how to convert in date
Thanks
M A hasan
M A hasan
And add 2 more ELSE clauses for double-digit days then you are ready.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>