When querying table TemporalTableBetween sql throws error non convertible datetime

[Ilkhom-S]

When use TemporalTableBetween extension. Datetimes can't converted to datetime2 in sql

Exception:

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string.

[JonathanMagnan]

Hello @Ilkhom-S ,

Thank you for contacting us, we will look at it.

Best Regards,

Jon

---

Sponsorship
Help us improve this library

Performance Libraries
context.BulkInsert(list, options => options.BatchSize = 1000);
Entity Framework Extensions • Dapper Plus

Runtime Evaluation
Eval.Execute("x + y", new {x = 1, y = 2}); // return 3
C# Eval Function

[Ilkhom-S]

@JonathanMagnan , I found that only when current context culture is other than en-us exception thrown. I tested with ru-RU , it's giving error
on en-US its ok.

[JonathanMagnan]

Hello @Ilkhom-S ,

Do you think you could create a runnable project with the issue? It doesn’t need to be your project, just a new solution with the minimum code to reproduce the issue.

My developer told me that it worked when he did the culture test, so perharp we are missing something to reproduce it.

Best Regards,

Jon

[Ilkhom-S]

Hello, I create sample project to demonstrate problem.
You need to apply migration and run console app to see problem

https://github.com/Ilkhom-S/ZZZThreadBug

[Ilkhom-S]

I commented block where querying with ZZZ extension with default culture, because duplicate hook error was throwing.

[JonathanMagnan]

Hello @Ilkhom-S ,

It's possible that the GitHub repos is private? We currently receive a Page not found when trying to go in your repository: https://github.com/Ilkhom-S/ZZZThreadBug

If you need to keep the code private, you can send it here: [email protected]

Best Regards,

Jon

[Ilkhom-S]

Apologize. I make it public

[JonathanMagnan]

Hello @Ilkhom-S ,

Just to let you know that the issue has been fixed and should be released next week.

Best Regards,

Jon

[Ilkhom-S]

Thanks,

[JonathanMagnan]

Hello @Ilkhom-S ,

A new version has been released yesterday that should fix this issue.

If you have the chance to test it, let us know if everything has been fixed correctly.

Best Regards,

Jon

---

Are you finding this library useful? If so, please consider supporting its continued development by becoming a sponsor.

Additionally, if you think your enterprise would benefit from this library, we encourage you to suggest they become a sponsor as well. Your support will help ensure this library remains alive and well-supported.