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

Returns the spatial geometry object of a trajectory object within the specified time range.

Syntax

-- Pass start and end timestamps directly
geometry ST_subTrajectorySpatial(trajectory traj, timestamp starttime, timestamp endtime);

-- Pass a tsrange value
geometry ST_subTrajectorySpatial(trajectory traj, tsrange range);

Parameters

Parameter	Description
`traj`	The trajectory object.
`starttime`	The start time.
`endtime`	The end time.
`range`	The time range.

Examples

Select ST_subTrajectorySpatial(traj, '2010-1-11 02:45:30', '2010-1-11 03:00:00') FROM traj_table;