Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: operator does not exist: timestamp without time zone + integer - Mailing list pgsql-general

From Andrew Gierth
Subject Re: ERROR: operator does not exist: timestamp without time zone + integer
Date
Msg-id 87d0l3v8t9.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: ERROR: operator does not exist: timestamp without time zone +integer  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: ERROR: operator does not exist: timestamp without time zone +integer  (Ray O'Donnell <ray@rodonnell.ie>)
Re: ERROR: operator does not exist: timestamp without time zone +integer  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
>>>>> "Adrian" == Adrian Klaver <adrian.klaver@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

-- 
Andrew (irc:RhodiumToad)

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Amazon Linux Support?
Next
From: Ray O'Donnell
Date:
Subject: Re: ERROR: operator does not exist: timestamp without time zone +integer