3,072 reputation
22046
bio website n/a
location
age 38
visits member for 3 years, 5 months
seen Dec 19 at 18:18

Dec
17
awarded  Notable Question
Nov
24
awarded  Notable Question
Nov
10
comment DateTime returning with AM/PM
"It must be something in the app" is correct. I've spent four days hunting this down. Down one path, we're using one method of formatting. Down another path, we format it differently. Thanks for the input. Marking as accepted since the question wasn't really valid. :\
Nov
10
accepted DateTime returning with AM/PM
Nov
10
comment DateTime returning with AM/PM
I try connecting from the Win2003 box to the SQL Server on the Win2008 box (which is giving me milliseconds on another box) and I still get the AM/PM format. That's why I think it's driver. I'll try going the other way to see what happens (Win2008 box connecting to the win2003 server.) And yes, everything is running under the accounts that I log in with. (Great tip, though!)
Nov
10
comment DateTime returning with AM/PM
Yes. It's the same thing. However, the SQL Server drivers are different. The version 6.0.1 driver (on Win2008) is giving me milliseconds and the version 2000 (on Win2003) is giving me AM/PM.
Nov
10
revised DateTime returning with AM/PM
added 30 characters in body
Nov
10
comment DateTime returning with AM/PM
Actually, I tried setting these values and retesting. I'm still getting AM/PM and non-24-hour format.
Nov
10
comment DateTime returning with AM/PM
I tried multiple languages on the client machine with no changes. It turns out it's in the "Customize" settings! Thanks for the answer, it led me down the right path.
Nov
10
comment DateTime returning with AM/PM
Most of the Google results in this area involve the "CONVERT" function. But that is definitely not going on here.
Nov
10
asked DateTime returning with AM/PM
Oct
9
awarded  Popular Question
Aug
1
awarded  Yearling
Jul
2
awarded  Curious
Jun
23
awarded  Famous Question
Jun
19
awarded  Notable Question
Jun
5
awarded  Famous Question
Apr
7
awarded  Custodian
Apr
7
reviewed Approve Installing pgcrypto Extension
Mar
31
awarded  Nice Question