DatetimeTZ

An ISO 8601 compliant date and time type with time zone information.

Syntax

A datetime-tz literal consists of a datetime followed by a time zone specification.

A time zone may be specified in two formats:

  • the ISO 8601 time offset from UTC: ±HH, ±HH:MM, ±HHMM, or Z;

  • the IANA time zone database TZ identifier (usually <Area>/<Location>, e.g. Europe/London).

The IANA TZ identifier is separated from the datetime by a space character.

Example datetime-tz literals
2024-03-30T12:00:00Z
+12345-09-21T12:34:56.789+0100
1887-12-22T17:29 Asia/Kolkata
1920-04-26T16:30-09:30

#!test[read]
#{{
match
  let $w = 2024-03-30T12:00:00Z;
  let $x = +12345-09-21T12:34:56.789+0100;
  let $y = 1887-12-22T17:29 Asia/Kolkata;
  let $z = 1920-04-26T16:30-09:30;
#}}

Defining a datetime-tz valued attribute

#!test[schema]
define
  attribute scheduled-meeting-time value datetime-tz;

Inserting a datetime-tz valued attribute

#!test[write]
insert
  $_ isa scheduled-meeting-time 2025-01-10T12:34:56 Europe/London;