GetPreviousValid function

The GetPreviousValid function returns the last element before the given time stamp.

Syntax

GetPreviousValid(ts     TimeSeries, 
                tstamp datetime year to fraction(5),
                flags  integer default 0) 
returns row;

ts: The source time series.
tstamp: The time stamp of interest.
flags: Valid values for the flags argument are described in The flags argument values. The default is 0.

The equivalent API function is ts_previous_valid().

A row containing the last element before the given time stamp. The type of the row is the same as the time series subtype.

If the time stamp is less than or equal to the time series origin, NULL is returned.

The following query gets the first element that precedes time stamp 2011-01-05 in a regular time series:

select GetPreviousValid(stock_data, 
   '2011-01-05 00:00:00.00000')
   from daily_stocks
   where stock_name = 'IBM';

The following query gets the first element that precedes time stamp 2011-01-05 in an irregular time series:

select GetPreviousValid(activity_data, 
   '2011-01-05 00:00:00.00000')
   from activity_stocks
   where stock_id = 600;