On 4/30/19 8:00 AM, Andrew Gierth wrote:
"Adrian" == Adrian Klaver <adrian.kla...@aklaver.com> 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.kla...@aklaver.com
