AGE_IN_MONTHS
Returns the difference in months between two dates, expressed as an integer.
Behavior Type
- Immutable if both date arguments are of data type
TIMESTAMP
- Stable if either date is a
TIMESTAMPTZ
or only one argument is supplied
Syntax
AGE_IN_MONTHS ( [ date1,] date2 )
Parameters
date1
|
Specify the boundaries of the period to measure. If you supply only one argument, Vertica sets date1 to
If date1 < date2, |
Examples
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)
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)