pt_centroid

Name and Parameters

pt_centroid( PostTIME ) : PostTIME

Description

Calculate the instant that is the middle of the argument's temporal bounding box.

Examples

SELECT pt_centroid('2013');
-- result
'CAL0012013-07-02T12:00:00.000Z'

SELECT pt_centroid('R21/2014-2-3/P1D/P2D');
-- result
'CAL0012014-03-07T00:00:00.000Z'

Processable Objects

| CAL | TCS | ORD ---|---|---|--- TM_Instant | ✔ | ✔ | ✗ TM_Period | ✔ | ✔ |✗ MultiInstant | ✔ | ✔ |✗ MultiPeriod | ✔ | ✔ |✗ RegularMultiInstant | ✔ | ✔ | - RegularMultiPerid | ✔ | ✔ | - ✔ : Processable

✗ : Call will cause an error

∼ : Callable without error, but returns only a pseudo result

Related functions

pt_temporal_bbox

---

List of SQL Functions