STS_GetSetOfTimesPassedByRegion function

Syntax

STS_GetSetOfTimesPassedByRegion(
                        ts           TimeSeries,
                        begin_time   DATETIME YEAR TO FRACTION(5),
                        end_time     DATETIME YEAR TO FRACTION(5),point ST_Point,
                        geometry     ST_Geometry)
returns SET(DATETIME YEAR TO FRACTION(5) not null)

ts

The name of the time series.

begin_time

The start of the time range. Can be NULL to indicate the first element in the time series.

end_time

The end of the time range. Can be NULL to indicate the last element in the time series.

geometry

The distance from the point that defines the border of the region of interest.

Usage

Run the STS_GetSetOfTimesPassedByRegion function to return the times within a time range when an object is near the specified position in a SET.

Returns

Returns a set of datetime values when an object is within a specified position in a SET

SELECT STS_GetSetOfTimesPassedByRegion(ts_track,'2017-02-02 13:00:00', '2017-02-02 13:03:30', 
ST_buffer(ST_Point(116.401, 39.911, 4326), 100, ‘meter’))
FROM t_vehicle 
WHERE modid='1';

SET{'2017-02-02 13:00:20.00000', '2017-02-02 13:00:43.00000', '2017-02-02 13:01:16.00000'}