Restructuring SQL queries according to SQL database Locale Settings
Posted on 2001-08-06
I have a client app (written in C++) that uses ADO to retrieve records from a SQL 7 server database table. The query performed uses datetime values as parameters in the format dd/mm/yyyy. The locale of the SQL Server table that I am accessing is US English. Consequently, when I perform queries using my app, no results are returned because the app month and day values are the wrong way round for the database table.
I was wondering whether there is a way of finding out (using code) what locale setting the SQL Server database is currently configured to, so that I can adjust the datetime parameters in the query in my app from dd/mm/yyyy to mm/dd/yyyy.