String was not recognized as a valid DateTime

Question

Hi team,

The data in my excel is in format dd-MM-yyyy but while copying to azure postgressql database, I am getting error saying that "String was not recognized as a valid DateTime". Could you please help me on this asap

Answer 1

Hello @Dinesh Prajapati , Thanks for the question and using MS Q&A platform.

I think you are putting the date format at dd/mm/yyyy as shown below and so getting the error .

When you create a datetime column in PG SQL the default format are already set

While reading the date, you can change the format

Thanks
Himanshu

Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.