Shankar K <shan0075(at)yahoo(dot)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