Omega - Support Information
Page Updated: 7-3-14
Reporting - Date Format Conversion
As anyone who has to create or maintain Omega reports discovers eventually, the application holds dates in a non-standard internal format. The value is held as a 2-byte unsigned integer and is a count of the number of days since 29th February 1948. This date format was chosen when Omega was designed for several reasons, including database query and rules engine calculation performance.
Unfortunately there are a number of problems with using this representation:
To solve the first issue there is a table within the database (sys_dateconv_table or sys_dateweek_table) to convert between the two formats and include in the report, though it can result in a performance hit depending on report complexity. To help the administrator with the second issue a number of solutions are described below:
Query the Omega database
Date Conversion Table
Date Conversion Utility
Web site Conversion Tool.
|This site is copyright © 2003-2017 Neil Hughes. All rights reserved.|
Company and product names on this site may be trademarks or registered trademarks and are hereby acknowledged.