Hi -

DF 20.0.7. MS SQL Express, DAW driver

I am saving records in a little table - well record size is little. The DateTime is set in the DD class and all records are saved by the exact same code & not updated after saving.

    Procedure Field_Defaults
        Forward Send Field_Defaults
        Set Field_Changed_Value Field HLDCalibrationProbeDataPoints.DataPointDateTime to (CurrentDateTime())
However, We get this:

Click image for larger version. 

Name:	SQL Datetime 12_24HR.jpg 
Views:	61 
Size:	136.9 KB 
ID:	15487

The time portion switches (seemingly at random) between 12 & 24 hour format.

When you are attempting to get the last 5 records by the datetime & average them, the above doesn't cut it. Yes, I can hack it & use ID, but why would it do this?