Hi all , I have one isue with date format , In my source file we are getting date format like below 20170610000000 20170611000000 20170612000000
In my staging table we have made the column datatype as time stamp, while loading process are getting failed because of this is there any way to change the date format while copying from file to staging table I tried to change the value of date format properties of s3 load component from "auto" to YYYYMMDD , but this also not worked for me
please suggest the best way to achieve the solution Thanks in advance , Regards, Vipin Jha
7 Community Answers
Laura Malins —
If you change the date format to YYYYMMDDHHMISS it will load.