In all prior versions, if you had a timestamp field, and you were setting that when a transaction happened, if you viewed those transactions in a grid, and you wanted them sorted by timestamp in descending order, this did not work. They weren’t necessarily in physical order by time, because if multiples were in the same minute, they were in a random order.
You had to add a secondary sort by ID descending to make sure that multiple transactions in the same minute were sorted correctly.
Because the default data type for a timestamp was “smalldatetime“ on MSSQL.
That does not include seconds.
So I would have to manually change the data type to date time if I wanted to show seconds on the screen.
NOW
I noticed that if I added “:ss“ to the end of a timestamp format, then it automatically changes it to “datetime“.
This is super minor, but it’s one nice thing to offset many of the annoyances that I have with V 10.
I still haven’t posted that thread
