datetimetz

An ISO 8601 datetimetime with timezone.

Same as datetime, but with timezone component included.

Optional Parameters

  • Value range constraint - datetimetz( min, max )

An optional range can be specified to a datetimetz in order to specify a restriction on permitted values. The values for min and max can be a ISO 8601 datetime string value or * to indicate wildcard maximum or minimum permitted value.

Examples

  • datetimetz("2000-01-01T08:00:00+01:00" ","2005-01-01T18:00:00+01:00") A datetime between 2 datetime values.
  • datetimetz(*,"2000-01-01T08:00:00+01:00") A datetime between lowest datetime supported by target language and “2000-01-01T08:00:00+01:00”.
  • datetimetz(""2000-01-01T08:00:00+01:00"",*) A datetime between “2000-01-01T08:00:00+01:00” and highest datetime supported by target language.