Thomas Lockhart <lockhart@fourpalms.org> writes:
>> ... The only way to cast to
>> timestamp without tz is CAST( ... without time zone) as far as I can tell;
>> as ::timestamp(p) doesn't work nor the w/ w/o tz in that style of casting.
> Right. The double-colon syntax is an ancient PgSQL-ism. Use cast()
> instead to get the greatest variety of syntax in coersions.
AFAICT, double-colon accepts exactly the same range of type names as CAST
does. For example:
regression=# select 'now'::timestamp(3); timestamptz
----------------------------2002-02-25 22:58:44.796-05
(1 row)
regression=# select 'now'::timestamp(3) with time zone; timestamptz
----------------------------2002-02-25 23:00:04.235-05
(1 row)
regression=# select 'now'::timestamp(3) without time zone; timestamp
-------------------------2002-02-25 23:00:08.075
(1 row)
regression=# select 'now'::"timestamp"; timestamp
----------------------------2002-02-25 23:00:17.104784
(1 row)
regression=# select 'now'::"timestamptz"; timestamptz
-------------------------------2002-02-25 23:00:19.644908-05
(1 row)
>> Among other fun new timestamp changes ;)
> Enjoy ;)
Yup, we've got some. But hey, SQL99 compliance is good for you ;-)
regards, tom lane
