years_since
Years since given date (truncated)
years_since(date)
Parameters
years_since(date) - Complete calendar years since given date.
- date (date): A date value (e.g.,
first_trade_date)
Formula
Uses PostgreSQL's AGE function:
years_since = EXTRACT(YEAR FROM AGE(scan_date, date))
Examples
// Stocks that started trading within the last year
years_since(first_trade_date) < 1;
// Stocks with at least 5 years of trading history
years_since(first_trade_date) >= 5;
Returns
Integer (complete calendar years)