ISO 8601 Date and Time Support

Jade supports the ISO 8601 format (specified in https://www.rfc-editor.org/rfc/rfc3339) as well as the MicrosoftDateFormat for Date, Time, TimeStamp, and TimeStampOffset primitive types returned from a web service. To maintain the behavior of earlier releases, you can still use the old MicrosoftDateFormat.

This feature is not yet available for dynamic parsing. Timestamps are represented by strings, as they are in JSON RFC8259 format.

The use of the ISO 8601 format is enabled on the Define Application dialog for your REST web application by checking the Use ISO 8601 Time check box on the Web Options sheet. This check box is unchecked by default. The ISO 8601 format functionality is displayed on the Web Options sheet of the dialog only when the application selected in the Application Type list box on the Application sheet of this dialog is Rest Services or Rest Services, Non‑Gui.

When the Use ISO 8601 Time check box is checked, the application formats all Date, Time, TimeStamp, and TimeStampOffset primitive types in ISO 8601 format rather than MicrosoftDateFormat.

In addition, when a TimeStamp is returned from the web service in ISO 8601 format, it includes time zone offset information, similar to a TimeStampOffset. This is required because the consumer of the web service would not otherwise know the time zone to which the TimeStamp is local. As such, all TimeStamp primitive types are converted to UTC time and an offset included that represents by how many hours and minutes to offset the TimeStamp to get to local time.

You can specify the time zone that should be assumed for TimeStamp primitive types by typing or selecting the appropriate time zone IANA name from the Timestamp TimeZone combo box on the Web Options sheet of the Define Application dialog. The combo box is populated with Etc/UTC (Z) as well as the time zone in which the database server is located. You can select any time zone you require, by typing it in full.

The JadeJson class provides the following properties and method to enable the ISO 8601 format.

useISO8601 property, which has a Boolean value. Set the property to true to use the ISO 8601 format instead of the MicrosoftDateFormat.
offsetForTimeStamps property, which has an Integer value. Set this property to the number of minutes by which you want to offset TimeStamp values. Alternatively, you can set this from a time zone name by using the setOffsetForTimeStamps method.
setOffsetForTimeStamps method, which enables you to specify the name of a time zone that can be the IANA or Windows name, and sets the offsetForTimeStamps property to the value of the offset of the specified time zone.

2022.0.01 and higher