I have a SQL Server database (2008R2) running on a Windows 2003 box. I'm connecting to it using another Win2003 box.
When I select a datetime value from the database, I'm getting it back in this format:
11/5/2014 12:07:46 PM
However, when I'm using a different system (Win2008 connecting to a 2008R2 database), I'm getting it back in a more expected format:
In both of these cases, I'm pulling the values through a Microsoft OLE DB driver directly from the database tables. The SELECT statements are not converting these values in any way. This is being pulled from some C++ code and logged to a file. When I connect using SSMS, the values are always in a more expected format (no AM/PM).
Why am I getting two separate formats from the same version of SQL Server? Is this an OLE DB Driver setting somewhere?