| From: | "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Timestamp with zero precision |
| Date: | 2003-08-12 14:02:22 |
| Message-ID: | 00b301c360da$5b58d030$98a0a8c0@dgtac |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greetings,
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.
Thanks in advance.
--------------------------------------------------------------------------------
José Vilson de Mello de Farias
Software Engineer
Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson(dot)farias(at)digitro(dot)com(dot)br
Tel.: +55 48 281 7158
ICQ 11866179
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-08-12 14:07:18 | Re: 7.4Beta1 "failed to create socket: Address family not |
| Previous Message | Tom Lane | 2003-08-12 13:59:03 | Re: 7.4Beta1 "failed to create socket: Address family not |