ST_pointAtTime

更新时间:
复制 MD 格式

Returns the spatial point on a trajectory at the specified timestamp.

Syntax

geometry ST_pointAtTime(trajectory traj, timestamp t);

Parameters

ParameterTypeDescription
trajtrajectoryThe trajectory object.
ttimestampThe timestamp at which to sample the trajectory.

Return value

Returns a geometry value representing the spatial point on the trajectory at time t.

Examples

SELECT ST_pointAtTime(traj, '2010-1-11 23:40:00') FROM traj_table;