>>>>> "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 -- Andrew (irc:RhodiumToad)