Question 114470 in PostgreSQL Question posted in
The official documentation can be found here.

How do I get the date of birth from a full age in postgresql?

I have an age on the format 57 years 5 months 7 days, and I want to deduct the date of birth from it in postgresql on a format like yyyy-mm-dd, how do I do that?

Tags:

2

Answers


  1. 0

    We can get the past date using multiple intervals. I added a couple examples to the data to check that it’s working.

    select  *
       ,current_date + (interval '-1 years'*years) + (interval '-1 month'*months) + (interval '-1 day'*days) as dte
from    t
    years months days dte
    57 5 7 1965-04-18 00:00:00
    36 11 12 1985-10-13 00:00:00
    6 2 1 2016-07-24 00:00:00

    Fiddle

    Login or Signup to reply.
  2. 0

    Here’s a way with concat_ws

       select *, current_date - concat_ws (' ', years, 'years', months, 'months', days, 'days')::interval as dte
    from   t

    Here’s a way with make_interval

    select *, current_date - make_interval(years, months, 0, days) as dte
from   t

    Here’s a way with format

    select *, current_date - format('%s years %s months %s days', years, months, days)::interval as dte
from   t
    years months days dte
    57 5 7 1965-04-18 00:00:00
    36 11 12 1985-10-13 00:00:00
    6 2 1 2016-07-24 00:00:00

    Fiddle

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search