Topic: . i need to insert the date which is coming from csv file to the database my problem is the date is in formate 'yyyymmdd' i tried parsing it DateTime.ParseExact(dCRecord[7],
. i need to insert the date which is coming from csv file to the database my problem is the date is in formate 'yyyymmdd' i tried parsing it DateTime.ParseExact(dCRecord[7], "yyyyMMdd", CultureInfo.InvariantCulture) like this but it is not picking up the date?
Author: SHIVA
Not sure what course is right for you?
Choose the right course for you.Get the help of our experts and find a course that best suits your needs.
Let`s Connect
PARTH
In yyyymmdd , mm stands for minutes while in yyyyMMdd, MM stands for months. That is the difference, that is why you are getting error. Make both the formats same -> yyyyMMdd
FRAUSKY
Open your file in Excel AND check the data.