Problem with Dates

Поиск
Список
Период
Сортировка
От Sharon Cowling
Тема Problem with Dates
Дата
Msg-id 200204292102.g3TL2aN13459@lambton.sslnz.com
обсуждение исходный текст
Ответы Re: Problem with Dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi,

I'm inserting data into the database (via a JSP) and I'm getting the incorrect year sometimes.
The date is entered by the user (it is their birthdate) then inserted into the database as dd-mm-yy this works fine for
mostdates.  If I enter 16-10-76 it will be stored as 16/10/1976, but if I was to enter 16/10/56 it gets stored as
16/10/2056.

Could someone direct me to some documentation or tell me how to change the date settings?  I realise why it's setting
thedates this way, I just haven't been able to find how to change it. 

Thanks,

Sharon Cowling


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problems with compiling postgres 7.2.1 on HPUX
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem with Dates