Create custom configurations (optional)To customize your temporal database table's maximum date & time stamp in the psp_valid_to column, add the directive shown below within the <temporal> tag, replacing the red text with any value you would like to assign for custom configuration. <max_datetime>2030-12-31 00:00:00</max_datetime> NOTE: If records already exist in your temporal database table and then the <maxdatetime> value is changed, any records that were previously timestamped in the psp_valid_to column will not be updated to reflect the newly entered <max_datetime> value. You can also customize the column names for the psp_valid_from and psp_valid_to columns by modifying the values within the <column type="from"> and <column type="to"> directives, respectively.
Show If |
---|
| You can also setup precision fractional seconds for your temporal columns timestamps. In your agent.xml in the temporal tag, add the attribute precision_size. For example, <precision_size=3> "3"> will result in a timestamp similar to "2018-09-08 17:51:04.123" whereas <precision_size=4> "4"> will result in a timestamp similar to "2018-09-08 17:51:04.1234". |
|