[Postgres] Fixes #51315 : force datestyle to ISO

qgis · Mar 29, 2023 · 9f55ce5 · 9f55ce5
1 parent e51297b
commit 9f55ce5
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/src/providers/postgres/qgspostgresconn.cpp b/src/providers/postgres/qgspostgresconn.cpp
@@ -451,7 +451,7 @@ QgsPostgresConn::QgsPostgresConn( const QString &conninfo, bool readOnly, bool s
     // Quoting floating point values and application name for PostgreSQL connection in 1 request
     LoggedPQexecNR(
       "QgsPostgresConn",
-      QStringLiteral( "SET extra_float_digits=3; SET application_name=%1" ).arg( quotedValue( QgsApplication::applicationFullName() ) )
+      QStringLiteral( "SET extra_float_digits=3; SET application_name=%1; SET datestyle='ISO'" ).arg( quotedValue( QgsApplication::applicationFullName() ) )
     );
   }