Date calculation - Mailing list pgsql-general

From Ron
Subject Date calculation
Date
Msg-id c10b17de-623b-4af3-8a8c-45c4a3a5826d@gmail.com
Whole thread Raw
Responses Re: Date calculation  (Bruce Momjian <bruce@momjian.us>)
Re: Date calculation  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List 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.


pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: oracle_fwd - is it safe or not?
Next
From: Bruce Momjian
Date:
Subject: Re: Date calculation