Re: BUG #1517: SQL interval syntax is accepted by the parser, - Mailing list pgsql-bugs

Bruce>     test=> select timestamp with time zone '2004-01-01';


Also, FWIW, according to the postgres doc this is a postgresism.  The
'with time zone' clause never occurs in an ANSI timestamp literal;
whether it is a timestamp or a timestamp with time zone depends on
whether a time zone specification is included in the literal string.

     -roy