Re: Error Retrieving Date Records

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