Using timestamp data from the request header

Several timestamp fields, such as InquiryAsOfDate, InquiryToDate, and InquiryFromDate, are passed in the request header (DWLControl object). These timestamp fields are normally used in PIT queries, and are passed as string objects before being reformatted and converted to timestamps.

Based on the way they are used, InquiryAsOfDate and InquiryToDate are normally formatted to the end of the day (23:59:59) and InquiryFromDate is formatted to the beginning of the day (00:00:00). These fields cannot be converted to UTC in the DWLControl object, and must instead be converted to UTC after the formatting has been completed.

Since values for H_CREATE_DT, LAST_UPDATE_DT, and H_END_DT are saved in UTC, you need to convert the header timestamp fields to UTC using PIT queries.

Avoid using the fields directly from the DWLControl object. Instead, use the following methods in the DWLCommonControl class to retrieve these fields in the corresponding component classes:
  • getPITHistoryDate – This method first formats the date fields to the end of the day and then, if multi time zone deployment is enabled, the method converts the date field to UTC format. Use this method to format InquiryAsOfDate and InquiryToDate.
  • getPITHistoryFromDate – This method first formats the date fields to the beginning of the day and then, if multi time zone deployment is enabled, the method converts the date field to UTC format. Use this method to format InquiryFromDate.
  • getPITHistoryDateField – This method does not format the date field, but if multi time zone deployment is enabled, it will convert the date field to UTC format.
Note: Most often, the timestamp fields in the request header are used in PIT queries at the component layer. If these fields being used outside of the component, ensure that it is converted to UTC before being used in any business logic. You can use the utility method available in DWLDateTimeUtilities to convert timestamp fields to UTC.