Vertica Analytics Platform Version 9.2.x Documentation
Returns the difference in months between two dates, expressed as an integer.
- Immutable if both date arguments are of data type TIMESTAMP
- Stable if either date is a TIMESTAMPTZ or only one argument is supplied
AGE_IN_MONTHS ( [ date1,] date2 )
Specify the boundaries of the period to measure. If you supply only one argument, Vertica sets date2 to the current date. Both parameters must evaluate to one of the following data types:
If date1 < date2, AGE_IN_MONTHS returns a negative value.
Get the age in months of someone born March 2 1972, as of June 21 1990:
=> SELECT AGE_IN_MONTHS('1990-06-21'::TIMESTAMP, '1972-03-02'::TIMESTAMP); AGE_IN_MONTHS --------------- 219 (1 row)
If the first date is less than the second date, AGE_IN_MONTHS returns a negative value
=> SELECT AGE_IN_MONTHS('1972-03-02'::TIMESTAMP, '1990-06-21'::TIMESTAMP);
Get the age in months of someone who was born November 21 1939, as of today:
=> SELECT AGE_IN_MONTHS ('1939-11-21'::DATE); AGE_IN_MONTHS --------------- 930 (1 row)
Was this topic helpful?