ST_pointAtTime
Updated at:
Copy as MD
Returns the geometry object at a specific point in time from a trajectory object.
Syntax
geometry ST_pointAtTime(trajectory traj, timestamp t);Parameters
| Parameter | Type | Description |
|---|---|---|
traj | trajectory | The trajectory object. |
t | timestamp | The time point to query. |
Return value: A spatial point of type geometry.
Example
SELECT ST_pointAtTime(traj, '2010-1-11 23:40:00') FROM traj_table;Is this page helpful?