Why would DateTime.Now.Date formats differ between systems?

Question

Why on one system would the default time be 12:00:00 and on another 00:00:00

DateTime.Now.Date

Starting with string in a web ui, passing thru Nhibernate to SQL Server 2005. For example 6/10/2009 is entered in a textbox on a web server by the time it is caught in sql profiler I see 2 different times

00:00:00 on my local system (XP), Dev, Test, Staging (2003) 12:00:00 on Prod (2003)

Thanks for the quick replies

Regional settings and DateTime format are the same.

Answer 1

Regional/display settings for date/time formats

Answer 2

In the control panel, you can define the way it displays in regional settings:

H:mm:ss -> 24 hours you will see 00:00

h:mm:ss -> 12 hours format with am/pm you will see 12:00 am

Answer 3

It's always midnight, the display might be affected by the machine's local culture settings.

You might be interested in the Turkey Test for a whole slew of other things that can be affected by culture, like parsing doubles, formatting dates and times, etc.

Answer 4

12 hour vs 24 hour clock