The data type xs:time represents an instant of time that recurs every day.

Lexical form

The lexical form of the data type xs:time is hh:mm:ss.sssssssssssszzzzzz.

The lexical form of the data type xs:time is hh:mm:ss.sssssszzzzzz.

The following abbreviations describe this form:

  • hh
  • A two-digit numeral (with leading zeros as required) that represents the hours.
  • :
  • A separator between parts of the time portion.
  • mm
  • A two-digit numeral that represents the minute.
  • ss
  • A two-digit numeral that represents the whole seconds.
  • .ssssssssssssssssss
  • Optional. If present, a 1-to-12 digit numeral that represents the fractional seconds.
  • zzzzzz
  • Optional. If present, represents the time zone.

Example

The following form, which includes an optional time zone indicator, represents 1:20 p.m. Eastern Standard Time, which is five hours behind than Coordinated Universal Time (UTC):

13:20:00-05:00Copy code

Parent topic:

Date and time data types


https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzasp/rzasp_xstime.htm