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.