String was not recognized as a valid DateTime

Question

String was not recognized as a valid DateTime

Dinesh Prajapati 126

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

Dinesh Prajapati 126 Reputation points

2023-02-23T23:47:36.24+00:00

the date is getting converted to dd/MM/yyyy automatically and I am getting the error "String was not recognized as a valid DateTime". How could I avoid this from azure ETL

1 answer

Your answer

Dinesh Prajapati 126 Reputation points

2023-02-23T23:47:36.24+00:00

the date is getting converted to dd/MM/yyyy automatically and I am getting the error "String was not recognized as a valid DateTime". How could I avoid this from azure ETL

Answer 1

HimanshuSinha-msft 19,486 Microsoft Employee Moderator

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 .

User's image

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

User's image

While reading the date, you can change the format User's image

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.

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2023-03-30T17:24:33.5133333+00:00

Hello @HimanshuSinha-msft , We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet . In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help . Thanks Himanshu

Share via

String was not recognized as a valid DateTime

1 answer

Your answer