This function returns a set of time points when a trajectory object passes through the specified spatial point.

Syntax

timestamp[] ST_timeAtPoint(trajectory traj, geometry g);

Parameters

Parameter Description
traj The trajectory object.
g The spatial point.

Example

Select ST_timeAtPoint(traj, st_geomfromtext('POINT(115 36)')) from traj_table;
     st_timeatpoint      
-------------------------
 {"2010-01-01 15:00:00"}