<div>
Thanks missionimpossible,<br />
<br />
Mission accomplished
</div>


Thanks missionimpossible,

Mission accomplished

<div>
<div class="content wysiwyg-content">
I have a client app (written in C++) that uses ADO to retrieve records from a SQL 7 server database table. &nbsp;The query performed uses datetime values as parameters in the format dd/mm/yyyy. &nbsp;The locale of the SQL Server table that I am accessing is US English. &nbsp;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.<br />
<br />
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.
</div>
</div>


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.

Restructuring SQL queries according to SQL database Locale Settings

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.