This function returns the time point when the movement arrives at a spatial point from the start point for the specified distance.


timestamp[] ST_timeAtDistance(trajectory traj, float8 d);


Parameter Description
traj The trajectory object.
d The distance of movement.

This function returns an array of timestamps. Multiple spatial points may be at the same distance from the start point.


Select ST_timeAtDistance(traj, 100) from traj_table;