how to convert string to date format yyyy-mm-dd in c#?
Hi Smita, Please use to_char(to_date('20130731′,'yyyymmdd'),'yyyy/mm/dd'). When you work with date in files use YYYYMMDD format also need to specify the date format in file properties tab either for source or target date format.