Duration

About

An attribute value may hold a duration

A duration is:

• a period of time,
• a directed distance between two points on the time-line.

This article shows you how to write a duration value.

Formats

Simplified ISO

We support a simplified iso format that is less verbose.

The below table shows some examples:

The format is:

(n)d(n)h(n)m(n)s

where:

• (n) is a decimal (mandatory)
• (n)d is the number of days
• (n)h is the number of hour
• (n)m is the number of minutes
• (n)s is the number of second
• (0.nnn)s is the number of milliseconds

ISO-8601 standard

We support the full iso format

Example:

The ISO 8601 Durations are expressed using the following format:

P(n)DT(n)H(n)M(n)S

where:

• (n) is a decimal (ex: for milliseconds, 0.500S)
• P is the duration designator (referred to as period), always present
  • D is the day
• T is the time
  • H is the hour
  • M is the minute
  • S is the second

Limitations

We support only Fixed time units:

• days,
• hours,
• minutes,
• seconds,
• nanoseconds

We don't support:

• Month (may be 28 or 31 days)
• Week
• Year