Problem with Dates - Mailing list pgsql-novice

From Sharon Cowling
Subject Problem with Dates
Date
Msg-id 200204292102.g3TL2aN13459@lambton.sslnz.com
Whole thread Raw
Responses Re: Problem with Dates
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with compiling postgres 7.2.1 on HPUX
Next
From: Tom Lane
Date:
Subject: Re: Problem with Dates