On Aug 3, 2004, at 4:22 PM, Pedro B. wrote:
> Is it possible to make it something like 'yyyy-mm-dd hh:mm:ss:cc' ?
> (basically, a DATE and a TIME, but with 2 decimal cases on the :cc and
> not .ccccc as the TIME format.
timestamp and timestamptz both take an optional precision parameter.
What you want is timestamp(2) or timestamptz(2), I believe.
Michael Glaesemann
grzm myrealbox com