ST_pointAtTime

更新时间:
复制 MD 格式

Returns the spatial point of a trajectory object at the specified timestamp.

Syntax

geometry ST_pointAtTime(trajectory traj, timestamp t);

Parameters

ParameterTypeDescription
trajtrajectoryThe trajectory object.
ttimestampThe 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;