add_date_int add_interval_interval add_timestamptz_interval bool_in bool_out cstring2text date_in date_out date_to_timestamp date_to_timestamptz float_exp float_ln float_log10 float_round interval_cmp interval_in interval_make interval_out minus_date_date minus_date_int minus_timestamptz_interval minus_timestamptz_timestamptz mul_interval_double text2cstring text_cmp text_copy text_initcap text_lower text_out text_upper textcat_text_text time_in time_out timestamp_in timestamp_out timestamp_to_date timestamptz_in timestamptz_out timestamptz_shift timestamptz_to_date

add_timestamptz_interval() TimestampTz add_timestamptz_interval ( TimestampTz  t, const Interval *  interv  ) Return the addition of a timestamp and an interval. Note that interval has provisions for qualitative year/month and day units, so try to do the right thing with them. To add a month, increment the month, and use the same day of month. Then, if the next month has fewer days, set the day of month to the last day of month. To add a day, increment the mday, and use the same time of day. Lastly, add in the "quantitative time". Parameters [in] t Timestamp [in] interv Interval Returns On error return DT_NOEND Note PostgreSQL function: timestamp_pl_interval(PG_FUNCTION_ARGS)