NEW3.00.00 · Released 6 July 2016

NEWfinPOWER Connect

Released in

3.00.00

6 July 2016

1. Opened10 Apr
2. Closed10 Apr
3. Released6 Jul

Article 13761 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.