now() + '4d' AT TIME ZONE issue

From: Madison Kelly <linux(at)alteeve(dot)com>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: now() + '4d' AT TIME ZONE issue
Date: 2009-07-08 18:33:21
Message-ID: 4A54E671.6040602@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 the error:
ERROR: syntax error at or near "AT"
LINE 1: ...ME ZONE 'America/Toronto', now() + '4d' AS future AT TIME ZO...

I've tried using an embedded SELECT and CASTing it as a TIMESTAMP with
no luck.

SELECT
now() AT TIME ZONE 'America/Toronto',
CAST ((SELECT now() + '4d') AS TIMESTAMP) as future AT TIME ZONE
'America/Toronto';
ERROR: syntax error at or near "AT"
LINE 1: ...ST ((SELECT now() + '4d') AS TIMESTAMP) as future AT TIME ZO...

When I remove the 'AT TIME ZONE' from the offset now in either case the
SELECT works.

Someone mind beating me with a clue stick? Thanks!

Madi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ms swati chande 2009-07-08 18:34:01 Re: [Re: Password?]
Previous Message Dan Armbrust 2009-07-08 18:30:05 Re: Checkpoint Tuning Question