Article Details
Id: | 13761 |
Product: | finPOWER Connect |
Type: | NEW |
Version: | 3.00.00 |
Opened: | 10/04/2016 |
Closed: | 10/04/2016 |
Released: | 06/07/2016 |
Job: | J017213 |
Database Dates; Created/Updated etc. UTC dates now stored in full precision
Created/ Updated etc. UTC date/times are now stored in SQL Server Databases in full precision, i.e. fractions of seconds are now stored. Previously the accuracy was to the nearest second.
In addition, Created/ Updated etc. UTC dates on objects now set the DateTimeKind properly, i.e. finDepartment.CreatedUtcDate will have a DateTimeKind of Utc, whereas CreatedDate will have a DateTimeKind of Local.
Note, this does not apply to Access databases as their precision is only to seconds.