DateTime returning with AM/PM 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:


  2014-11-02 10:53:00


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).

My Question:
Why am I getting two separate formats from the same version of SQL Server?  Is this an OLE DB Driver setting somewhere?
Your regional settings control the way dates are displayed. Try changing settings there.