Hi All,
I have to populate an oracle table from an Excel sheet.
Converted the Excel sheet to a csv file, using sequential file stage to read it. Date field in the excel sheet in excel format ( like 38895) .
How to convert this to Standard Date Format ( YYYYMMDD) ?
Any help is appreciated..
How to convert Excel date
Moderators: chulett, rschirm, roy