Skip site navigation (1) Skip section navigation (2)

Error Retrieving Date Fields from tables

From: Bhuvaneswari <bhuvana(at)linux(dot)ceedees(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Error Retrieving Date Fields from tables
Date: 2001-05-12 08:26:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
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

pgsql-jdbc by date

Next:From: The Hermit HackerDate: 2001-05-12 16:44:31
Subject: Displaying/Pulling Images using JDBC ...
Previous:From: Olivier DenierDate: 2001-05-11 16:16:27
Subject: moveToInsertRow() : Method Not Implemented

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group