GetStamp function

The GetStamp function returns the time stamp associated with the supplied offset in a time series. Offsets can be positive or negative integers.

Syntax

GetStamp(ts     TimeSeries, 
        offset integer) 
returns datetime year to fraction(5);
ts
The source time series.
offset
The offset.

Description

The equivalent API function is ts_time().

Returns

The time stamp that begins the interval at the specified offset.

Example

The following query returns the time stamp of the beginning of a time series:
select GetStamp(stock_data,0)
   from daily_stocks
   where stock_name = 'IBM';

Copyright© 2018 HCL Technologies Limited