two digit years in inserts

Поиск
Список
Период
Сортировка
От Justin Wyer
Тема two digit years in inserts
Дата
Msg-id 4163F389.4070106@isogo.co.za
обсуждение исходный текст
Ответы Re: two digit years in inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I have this problem, I wrote a script to insert data into a table, one
of the columns is a birthdate now I only have the last two year digits,
and this all worked fine. Until I did a portupgrade (i am running on bsd
5.2.1 and 4.8 and postgresql 7.3.6 & 7.3.7 respectively) script worked
fine before the upgrade, now however, any year before 70 gets inserted
as 20xx and not 19xx.

My question is between which versions did this behaviour change, and is
there any way for me to force the old behaviour?

Regards
Justin Wyer

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

Предыдущее
От: Justin Wyer
Дата:
Сообщение: (no subject)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Mirroring databases in v8