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.