Tom Lane wrote:
Madison Kelly 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
Thank you both, Chris and Tom. That was indeed my
ilto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Madison Kelly
> Sent: Wednesday, July 08, 2009 1:33 PM
> To: postgres list
> Subject: [GENERAL] now() + '4d' AT TIME ZONE issue
>
> Hi all,
>
>I'm trying to select an offset timestamp at a given
Madison Kelly 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Hi all,
I'm trying to select an offset timestamp at a given time zone, but I
can't seem to get the syntax right.
What I am *trying* to do, which doesn't work:
SELECT
now() AT TIME ZONE 'America/Toronto',
now() + '4d' AS future AT TIME ZONE 'America/Toronto';
Which generates
