Help Please: GridDateTimeColumn Milliseconds

[Casey]

Good Morning,

I am binding a RadGrid GridDateTimeColumn to a DB2 datetime column that contains millisecond values. I need to use these millisecond values to be able to update/delete the proper rows from the DB2 table; however, it looks like the GridDateTimeColumn doesn't store the System.DataTime value all the way down to milliseconds. It looks like the value just stops at seconds. 

Am I correct that the RadGrid GridDateTimeColumn doesn't store date/time values down to the millisecond?

Thanks
Casey

EDIT***
I was able to change the DataFormatString to "{0:MM/dd/yyyy HH:mm:ss:ffffff}" and it worked!! 

[Radoslav]

Hi Casey,

If you do not specify the DataFormatString property of the GridDateTimeColumn it uses:

• "d" (Short date pattern. For example: 6/15/2009)  as a format specifier if the picker type is DatePicker
• "t" (Short time pattern . For example: 1:45 PM) if the picker type is TimePicker
• "G" (General date/time pattern . For example: 6/15/2009 1:45:30 PM) if the PickerType is not specified

More information you could find in the following article:
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx

Best wishes,
Radoslav
the Telerik team