Re: Timestamp with zero precision

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp with zero precision
Date: 2003-08-12 14:22:06
Message-ID: 1522.1060698126@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2003-08-12 14:26:17 Re: Update of foreign key values
Previous Message Shridhar Daithankar 2003-08-12 14:14:33 Re: Timestamp with zero precision