now() + '4d' AT TIME ZONE issue
| От | Madison Kelly |
|---|---|
| Тема | now() + '4d' AT TIME ZONE issue |
| Дата | |
| Msg-id | 4A54E671.6040602@alteeve.com обсуждение исходный текст |
| Ответы |
Re: now() + '4d' AT TIME ZONE issue
Re: now() + '4d' AT TIME ZONE issue |
| Список | 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
В списке pgsql-general по дате отправления: