Timestamp with zero precision

On 12 Aug 2003 at 11:02, Vilson farias wrote:

Is there a way to set a "timestamp compatibility mode" for PostgreSQL
7.3.3's timestamp with older versions of database (like 7.1.2)? I'd like to
set all timestamps to have precision = zero (hh:mm:ss only, without any
millisecond).

I'm asking this because since I upgraded from 7.1.2 to 7.3.3 all my
aplications are raising lots and lots of errors due conversions from
timestamps to strings and it's gonna be very hard to fix all of them and I need
to avoid database re-creation of database structures.

Well a timestamp will always store a millisecond. It's just that it won't show
you.

May be you can create a view that will use date-time functions to select only
required part? Will that help you?

HTH

Bye
Shridhar

--
Rules for driving in New York: (1) Anything done while honking your horn is
legal. (2) You may park anywhere if you turn your four-way flashers on. (3) A
red light means the next six cars may go through the intersection.

"Vilson farias" <vilson.farias@digitro.com.br> writes:

Is there a way to set a "timestamp compatibility mode" for PostgreSQL
7.3.3's timestamp with older versions of database (like 7.1.2)? I'd like to
set all timestamps to have precision =3D zero (hh:mm:ss only, without any
millisecond).

Create the timestamp columns as
timestamp(0) with time zone

regards, tom lane