Postgres Pro
Downloads
Home   >   mailing lists

Re: now() + '4d' AT TIME ZONE issue - Mailing list pgsql-general

From Tom Lane
Subject Re: now() + '4d' AT TIME ZONE issue
Date
Msg-id 25453.1247078742@sss.pgh.pa.us
Whole thread Raw
In response to now() + '4d' AT TIME ZONE issue  (Madison Kelly <linux@alteeve.com>)
Responses Re: now() + '4d' AT TIME ZONE issue
List pgsql-general
Tree view 
Madison Kelly <linux@alteeve.com> writes:
> SELECT
>     now() AT TIME ZONE 'America/Toronto',
>     now() + '4d' AS future AT TIME ZONE 'America/Toronto';

You've got "AS future" in the wrong place.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Checkpoint Tuning Question
Next
From: Ms swati chande
Date:
Subject: Re: Password?