ISO 8601 Date and Time Support

Jade supports the ISO 8601 format (specified in https://www.rfc-editor.org/rfc/rfc3339), MicrosoftDateFormat (specified in https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings), and Jade style format for Date, Time, TimeStamp, and TimeStampOffset primitive types returned from a web service (in addition to the default generic timestamp parsing behavior). For details about the Jade style format, see "Converting Primitive Types", in Chapter 1 of the Developer's Reference. To maintain the behavior of earlier releases, you can still use the old MicrosoftDateFormat.

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

Enable the ISO 8601 format for responses from your REST web application by checking the Use ISO 8601 Time check box on the Web Options sheet of the Define Application dialog. This check box is unchecked by default. In addition, the check boxes in the Strict DateTime Parsing group enable you to enforce strict parsing of the specified date and time formats in requests to your REST application. Strict parsing means that Jade accepts only the specified format (or formats), whereas the default behavior is generic (and allows other formats).

The ISO 8601 format and strict date and time parsing functionality are 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 (and UTC offset) 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.

To enforce strict parsing of times and dates, check one or more of the following check boxes in the Strict DateTime Parsing group.

ISO8601, to enforce strict parsing of ISO 8601 format dates and times. The default value is false.
Jade Style, to enforce strict parsing of strict parsing of dates and times in the format Jade uses. The default value is false.
Microsoft Date Format, to enforce strict parsing of MicrosoftDateFormat format dates and times. The default value is false.

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

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. This property contains the offset in minutes from the JadeTimeZone zone to UTC when the setOffsetForTimeStamps method is called.
offsetTimeZone property, which contains the JadeTimeZone to use for time conversions. The setOffsetForTimeStamps method sets the JadeTimeZone.
setOffsetForTimeStamps method, sets the offsetTimeZone property value, which is used for time conversions during parsing.
parseDateTimeISO8601Strict property, which has a Boolean value. Set the property to true to enforce strict parsing of ISO 8601 format dates and times.
parseDateTimeJadeStyleStrict property, which has a Boolean value. Set the property to true to enforce strict parsing of dates and times in the format Jade uses.
parseDateTimeMicrosoftDateFormatStrict property, which has a Boolean value. Set the property to true to enforce strict parsing of MicrosoftDateFormat format dates and times.

2022.0.01 and higher