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

Restrictions

Comparisons

Miscellaneous