Reputation
3,677
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
4 25 53
Newest
 Revival
Impact
~335k people reached

Apr
29
awarded  Revival
Apr
25
awarded  Enlightened
Apr
25
awarded  Nice Answer
Apr
24
awarded  Nice Question
Apr
22
awarded  Revival
Apr
18
awarded  Revival
Apr
12
awarded  Famous Question
Mar
22
awarded  Famous Question
Mar
16
awarded  Popular Question
Dec
21
awarded  Favorite Question
Dec
9
awarded  Good Question
Nov
9
awarded  Nice Question
Aug
1
awarded  Yearling
Jul
6
awarded  Good Question
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.