On 1/31/19 2:15 PM, Bruce Momjian wrote:
On Thu, Jan 31, 2019 at 02:11:14PM -0600, Ron wrote:
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)
Uh, this worked:
SELECT date_trunc('week', CURRENT_TIMESTAMP) + '6 days';
?column?
------------------------
2019-02-03 00:00:00-05
Perfect! All I had to do was cast that as DATE...
Thanks
--
Angular momentum makes the world go 'round.
