Convert date from MMDDCCYY to YYYYMMDD
I have imported data from a fixed length format file into an external table in oracle which has several date fields in the format MMDDCCYY. I want to convert this into YYYYMMDD and insert it into another table in oracle with date field. A subset of the values to be converted is given below:
Any idea anybody.......
Tags for this Thread
Click Here to Expand Forum to Full Width