Re: Timezone Inconsistancies

Thomas Lockhart <lockhart(at)fourpalms(dot)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