The ability to preserve milliseconds in EDP is possible with a small change to the EQuIS Format Definition (EFD) file. By default, all dateTime values are truncated to seconds. This functionality can be altered by adding a custom edd:format attribute to the column in the EFD as shown:
<xs:element name="start_date" type="xs:dateTime" edd:format="yyyy-MM-dd HH:mm:ss.fff" nillable="false">
With this change to the *.xsd, milliseconds can be loaded into a datetime field in the database. Please note the following constraints associated with this modification:
1.The datetime data type in SQL Server rounds milliseconds to the nearest 1/300 of a second. The third digit will always end up as 0, 3, or 7 (e.g., "2013-02-20 06:08:00.111" will end up in the database as "2013-02-20 06:08:00.110").
2.Milliseconds will not be displayed in the package tab in EDP, because it uses the operating system time format. The millisecond precision is still there, however, and will be loaded into the database.
3.Viewing the data in EQuIS Professional will also not show the milliseconds for the same reason stated in number 2. Milliseconds can be seen as they exist in the database in an export from Professional to Excel, after changing the Excel column's formatting.
4.If an EDD is saved from EDP, the milliseconds will be lost. However, if the milliseconds are already in the EDD being loaded, they will be preserved.
Copyright © 2022 EarthSoft, Inc • Modified: 16 Mar 2022