Temporal Types

Input and Output

  • asText: Return the Well-Known Text (WKT) representation

  • asMFJSON: Return the Moving Features JSON (MF-JSON) representation

  • asBinary, asHexWKB: Return the Well-Known Binary (WKB) or the Hexadecimal Well-Known Binary (HexWKB) representation

  • ttypeFromMFJSON: Input from a Moving Features JSON (MF-JSON) representation

  • ttypeFromBinary, ttypeFromHexWKB: Input from the Well-Known Binary (WKB) or from the Hexadecimal Well-Known Binary (HexWKB) representation

Constructors

  • ttype: Constructor for temporal types from a base value and a time value

  • ttypeSeq: Constructor for temporal types of sequence subtype

  • ttypeSeqSet, ttypeSeqSetGaps: Constructor for temporal types of sequence set subtype

Conversions

Accessors

Transformations

  • ttypeInst, ttypeSeq, ttypeSeqSet: Transform a temporal value to another subtype

  • setInterp: Transform a temporal value to another interpolation

  • shiftTime, scaleTime, shiftScaleTime: Shift and/or scale the time span of a temporal value by one or two interval

  • unnest: Transform a nonlinear temporal value into a set of rows, each one containing a base value and a period set during which the temporal value has the base value

Modifications

  • insert: Insert a temporal value into another one

  • update: Update a temporal value with another one

  • deleteTime: Delete the instants of a temporal value that intersect a time value

  • appendInstant: Append a temporal instant to a temporal value

  • appendSequence: Append a temporal sequence to a temporal value

  • merge: Merge temporal values

Restrictions

Comparisons

Miscellaneous