Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error Retrieving Date Records

Error Retrieving Date Records

From
Bhuvaneswari
Date:
hai,
I am developing some projects using postgresql-jdbc in RedHat Linux
6.5.2. When I store date fields in a table, it is stored with the
correct format I have specified, when we are viewing in psql. But, when
it comes with the program using jdbc, date field's format is changed.
Eg, table field looks like '04/04/2001' but, when it comes with JTable
or JTextField, it is shown in a reverse format like '2001/04/04'. I
tried to set up the Date format manually in the program, but retrieves
the same error. Also, I made a change in psql as 'set date to 'European'
and other formats' which does not produce any change. What is the
problem and how it could be overcome. Please do reply. Thanks in
advance.
bhuvana.

Re: Error Retrieving Date Records

From
Joseph Shraibman
Date:
Use a java.text.SimpleDateFormat to make it look however you want.

Bhuvaneswari wrote:
>
> hai,
> I am developing some projects using postgresql-jdbc in RedHat Linux
> 6.5.2. When I store date fields in a table, it is stored with the
> correct format I have specified, when we are viewing in psql. But, when
> it comes with the program using jdbc, date field's format is changed.
> Eg, table field looks like '04/04/2001' but, when it comes with JTable
> or JTextField, it is shown in a reverse format like '2001/04/04'. I
> tried to set up the Date format manually in the program, but retrieves
> the same error. Also, I made a change in psql as 'set date to 'European'
> and other formats' which does not produce any change. What is the
> problem and how it could be overcome. Please do reply. Thanks in
> advance.
> bhuvana.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com