I have a problem querying a date with connector 8.0.17
Posted by: Ernesto Peralta
Date: July 19, 2024 06:33AM

i have this code in the start of my project

System.Threading.Thread.CurrentThread.CurrentCulture=System.Globalization.CultureInfo.CreateSpecificCulture("es-DO")
System.Globalization.DateTimeFormatInfo.CurrentInfo.ShortDatePattern = "dd'/'MM'/'yyyy"

The problem is that my application handles the date in "dd/MM/yyyy" format, when I query a date with connector 8.0.16 or lower, it doesn't matter if it is from a stored procedure or a simple select, the date comes in "dd/MM/yyyy" format, but from version 8.0.17 to the most recent 9.0.0 when I consult a date it has the format "MM/dd/yyyy" causing errors in my program.

Is there a way to configure the connector's date format, or the connector's culture?

Thank you!

Options: ReplyQuote


Subject
Written By
Posted
I have a problem querying a date with connector 8.0.17
July 19, 2024 06:33AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.