time property

mdex:time properties represent an instant of time that recurs every day.

An mdex:time property represents the hour and minutes of an instance of time, with the optional specification of fractional seconds. A timezone is not allowed as part of the time representation.

The mdex:time format is:
hh ':' mm ':' ss {'.' s+}
where:
  • hh is a two-digit numeral that represents the hour. Use a leading zero for a single-digit hour, such as 04.
  • The second mm is a two-digit numeral that represents the minute.
  • ss is a two-digit numeral that represents the whole seconds.
  • '.' s+ is optional and, if present, represents the fractional seconds. The internal representation is only precise to the millisecond, which means that a specification of four or more digits is truncated to three digits.

A colon (':') is the separator between hours, minutes, and whole seconds, while a period ('.') is the separator for fractional seconds.

Be sure to use a leading zero for single-digit hours, minutes, and whole seconds.

Example of ingesting time properties

The following request updates Record 624 with two time properties:
<ingest:ingestRecords 
      xmlns:ingest="http://www.endeca.com/MDEX/ingest/1/0" 
      xmlns:mdex="http://www.endeca.com/MDEX/XQuery/2009/09">
   <ingest:addAssignments>
      <mdex:record>
         <FactSalesID>624</FactSalesID>
         <time1 type="mdex:time">13:25:43.261</time1>
         <time2 type="mdex:time">09:14:52</time2>
      </mdex:record>
   </ingest:addAssignments>
</ingest:ingestRecords>
Note that the time2 property uses a leading zero (i.e., "09") to specify the hour. Omitting the leading zero will cause the operation to fail, with a fault similar to this example:
<faultstring>Error applying updates: Unable to parse property 
value "9:14:52" for property "time2" with type "mdex:time" on 
record FactSalesID:624</faultstring>