See below image, The UpdateDate column show datetime containing 'AM' text But the CreateDate show datetime, text 'PM' is not shown.
these 2 columns are auto-generated, and data type is DateTime. Update Date is :8/19/2010 10:27:20 AM Create Date is :8/13/2010 1:59:00 PM [but PM is not shown]
If PM not shown, '8/13/2010 1:59:00' will be know as '8/13/2010 1:59:00 AM' by C# Code.
The Server is Sql Server R2. It's always ok before any today. Just last nigh shown as below image.
I think the a bug of Sql Server R2.
Could any one tell me why, and how to avoid it happened once more?
Thank you Every Much!