Re: ERROR: operator does not exist: timestamp without time zone + integer

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 4/30/19 8:00 AM, Andrew Gierth wrote:
> > > > > > "Adrian" == Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes:
>
>   Adrian> Or cast to a date:
>
>   Adrian> test=> select date_trunc('day', localtimestamp)::date + 7;
>
> yeesh. that's a very long-winded way to write current_date + 7

Yeah, I was just working of the OP's original DEFAULT:

site_mode_date timestamp NOT NULL DEFAULT date_trunc('day', 
LOCALTIMESTAMP)+7,


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx