Timestamp with zero precision

Поиск
Список
Период
Сортировка
От Vilson farias
Тема Timestamp with zero precision
Дата
Msg-id 00b301c360da$5b58d030$98a0a8c0@dgtac
обсуждение исходный текст
Ответы Re: Timestamp with zero precision  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: Timestamp with zero precision  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.4Beta1 "failed to create socket: Address family not
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Timestamp with zero precision