ST_pointAtTime
Returns the spatial point of a trajectory object at the specified timestamp.
Syntax
geometry ST_pointAtTime(trajectory traj, timestamp t);Parameters
| Parameter | Type | Description |
|---|---|---|
traj | trajectory | The trajectory object. |
t | timestamp | The timestamp at which to retrieve the spatial point. |
Return value: A spatial point (geometry).
Example
SELECT ST_pointAtTime(traj, '2010-1-11 23:40:00') FROM traj_table;