This topic describes the ST_cumulativeDistanceAtTime function. This function is used to compute the cumulative distance that a trajectory object covers when it moves from a specified position until a specified point in time arrives.
Syntax
float8 ST_cumulativeDistanceAtTime(trajectory traj, timestamp t);
Parameters
Parameter | Description |
---|---|
traj | The trajectory object whose movement distance you want to compute. |
t | The point in time at which the trajectory object stops moving. |
Examples
Select ST_cumulativeDistanceAtTime(traj, '2011-11-1 04:30:00') from traj_table;