Timestamp with zero precision
От | Vilson farias |
---|---|
Тема | Timestamp with zero precision |
Дата | |
Msg-id | 00b301c360da$5b58d030$98a0a8c0@dgtac обсуждение исходный текст |
Ответы |
Re: Timestamp with zero precision
Re: Timestamp with zero precision |
Список | 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.
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
José Vilson de Mello de Farias
Software Engineer
Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179
APC - Customer Oriented Applications
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179
В списке pgsql-general по дате отправления: