Madison Kelly <linux@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general