ST_timeAtPoint-PolarDB(PolarDB)-阿里云帮助中心

Returns all timestamps at which a trajectory object passes through a given spatial point.

Syntax

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

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

Query all timestamps at which the trajectory in traj_table passes through the point POINT(115 36):

SELECT ST_timeAtPoint(traj, ST_GeomFromText('POINT(115 36)')) FROM traj_table;

Output:

     st_timeatpoint
-------------------------
 {"2010-01-01 15:00:00"}