Re: timestamp with timezone

Shankar K <shan0075@yahoo.com> writes:
> some has centiseconds in them along with TZ. Now i'm
> wondering is there a way to just extract date and
> timestamp alone leaving the centisecods as well the TZ
> part.

You mean you want to round off to even seconds?  Try date_trunc,
or cast to "timestamp(0) with time zone".  To force stuff to be
rounded when it's stored, declare the column like that in the
first place.

            regards, tom lane