Problem with Dates

From: Sharon Cowling <sharon(dot)cowling(at)sslnz(dot)com>
To: "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Problem with Dates
Date: 2002-04-29 21:02:00
Message-ID: 200204292102.g3TL2aN13459@lambton.sslnz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 most dates. 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 the dates this way, I just haven't been able to find how to change it.

Thanks,

Sharon Cowling

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-04-29 22:39:15 Re: Problem with Dates
Previous Message Tom Lane 2002-04-29 16:31:41 Re: Problems with compiling postgres 7.2.1 on HPUX