DateOnly - en_GB date flipped from October to April.

[phillipmunn]

Running .NET 8 with Npgsql 8.0.3. The locale on my machine is en_GB as I'm based in the UK. The PostgreSQL server’s locale in Azure is en_US.utf8 and I don’t believe I can change it.

I have some fairly simple code which is filtering a column of type "Date" in based on a DateOnly? value being passed in to a method:

The from date being specified is: 4th October 2023.

When I then call .ToQueryString() I can see that the query has changed to become instead: 10/04/2023. Which I believe is then being interpreted as 10th April 2023 instead of 4th October 2023 giving me the wrong results from the database.

I've tried changing the thread culture of my code to be en-US. Wondering if this would give me the correct result. It doesn't. Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");

Is there some other trick if I cannot change the locale of the database? Is there some other setting I'd need to provide to prevent my date from being mis-interpreted?

Apologies if this is really trivial.

-- @__contactId_1='PCLIMP01'
-- @__from_Value_2='10/04/2023' (DbType = Date)
-- @__to_Value_3='10/04/2024' (DbType = Date)
SELECT j."AccountingSystemTenantId", j."JournalNumber", j."JournalLineNumber", j."AccountCode", j."AccountingSystem", j."AllocationReference", j."AllocationState", j."Amount", j."ContactId", j."ContactName", j."CreatedAt", j."CurrencyCode", j."CurrencyRate", j."DebitCredit", j."IsCustomer", j."IsSupplier", j."Period", j."SiteId", j."Source", j."SourceType", j."TransactionDate", j."TransactionDescription", j."TransactionReference", j."UpdatedAt", j."VatIndicator", j."WeekNumber"
FROM "JournalLineItems" AS j
WHERE j."AccountingSystemTenantId" = @__businessUnit_0 AND j."ContactId" = @__contactId_1 AND j."TransactionDate" >= @__from_Value_2 AND j."TransactionDate" < @__to_Value_3```