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
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 |