Date calculation

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Date calculation
Date: 2019-01-31 20:11:14
Message-ID: c10b17de-623b-4af3-8a8c-45c4a3a5826d@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

v9.6.6

Is there a built in function to calculate, for example, next Sunday?

For example,

postgres=# select current_date, next_dow(current_date, 'Sunday');
    date    |    date
------------|------------
 2019-01-31 | 2019-02-03
(1 row)

Thanks

--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2019-01-31 20:15:14 Re: Date calculation
Previous Message Rob Sargent 2019-01-31 19:54:53 Re: oracle_fwd - is it safe or not?