Re: Re: to_date problems (Re: Favor for Postgres User at WSI)

Поиск
Список
Период
Сортировка
От Andrew McMillan
Тема Re: Re: to_date problems (Re: Favor for Postgres User at WSI)
Дата
Msg-id 3A0EE783.70A6C3AF@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: to_date problems (Re: Favor for Postgres User at WSI)  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-bugs
Thomas Lockhart wrote:
>
> Because of the common and documented cutoff date (1970 currently, 1950
> in some other apps) used to solve this problem.

Most database software I have seen uses some form of setting to control
the actual date used here, and that is the most long-term solution.

something like:
set CENTURY_WINDOW TO '1980';

Would be nicest.

Regards,
                    Andrew.
--
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: Re: to_date problems (Re: Favor for Postgres User at WSI)
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Security problem in psql frontends