This function is used to convert an Adelia timestamp into ISO8601 format with time zone information.
Context
Windows client
Windows server
Java client
Java server
Adelia Web Client
Adelia Cloud client
Event Adelia client
Parameters
TIMESTAMP | Timestamp | Adelia Timestamp |
ALPHA | TimeZoneId | Time zone ID in IANA format, simple offset ([+-]HH:MI), or Z to indicate a UTC date. If this parameter is omitted, the timestamp is assumed to be a date in the system's time zone. Note: Only the Java version supports IANA identifiers. The Windows version only supports offsets and the UTC indicator, and does not indicate the time zone ID in the result. |
ALPHA | ISOTimestamp | ISO8601 formatted timestamp (YYYY-MM-DDTHH:MI:SS.MSS([+-]HH:MI[IdTimeZone]|Z). The time zone ID only appears in the Java version. Output parameter. For example: |
NUM_BIN_4 | ISOTimestampLength | ISOTimestamp variable length. |
BOOL | Rc | Function return code. *TRUE if successful, *FALSE if the input date is invalid or if the output result is truncated. Output parameter. |
Example
TIMESTAMP AdeliaTimestamp
ALPHA(128) IsoTimestamp
...
/* Timestamp in Adelia format without time zone
AdeliaTimestamp = &ALPHA_TIMESTAMP('2024-06-12T12:00:00.000000')
/* displays a timestamp relating to the local time zone: 2024-06-12T12:00:00.000+02:00[Europe/Paris]
CALL_DLL 'VaToolBx' 'VaToolBxFormatISO8601Timestamp' AdeliaTimestamp *blank IsoTimestamp 128 Rc
/* displays a UTC timestamp: 2024-06-12T12:00:00.000Z
CALL_DLL 'VaToolBx' 'VaToolBxFormatISO8601Timestamp' AdeliaTimestamp 'Z' IsoTimestamp 128 Rc
/* displays a timestamp relating to an offset: 2024-06-12T12:00:00.000+03:00
CALL_DLL 'VaToolBx' 'VaToolBxFormatISO8601Timestamp' AdeliaTimestamp '+03:00' IsoTimestamp 128 Rc
/* displays a timestamp relating to a time zone: 2024-06-12T10:07:32.976-07:00[America/Los_Angeles] - only works in Java (in C, put -07:00)
CALL_DLL 'VaToolBx' 'VaToolBxFormatISO8601Timestamp' AdeliaTimestamp 'America/Los_Angeles' IsoTimestamp 128 Rc
List of the VaToolBx functions by topic