Re: timestamp precision with or without timezones - Mailing list pgsql-general

From Tom Lane
Subject Re: timestamp precision with or without timezones
Date
Msg-id 22327.1081358662@sss.pgh.pa.us
Whole thread Raw
In response to timestamp precision with or without timezones  (mboes@tweag.net)
List pgsql-general
mboes@tweag.net writes:
> Is there a way of specifying the precision of a timestamp *with
> timezone* field? It works fine for timestamps *without* timezone

It's
    timestamp(n) with time zone
    timestamp(n) without time zone
and not any other variants that might seem natural.

Don't blame us, that's what the SQL standard says ;-)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cursors and Transactions, why?
Next
From: Jan Wieck
Date:
Subject: Re: Evening in NYC