Re: Date time format out of range???? - Mailing list pgsql-jdbc

From Tom Arthurs
Subject Re: Date time format out of range????
Date
Msg-id 4547292C.40602@jobflash.com
Whole thread Raw
In response to Date time format out of range????  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-jdbc
There is no 31 Sept, the month only has 30 days.

Luca Ferrari wrote:
> Hi,
> I'm using my java application to access a pg8 database, but now I'm getting
> the following error performing the following insert:
>
> [Logger - info] Preparing a statement for the query <INSERT INTO persona
>
VALUES('FRR999','LUCA','FERRARI','19/07/1978','0000000000000','000000000','00000','BLLLLLLLLLLLLLLLLLL','Modena','Modena','','31/9/2006','luca','31/9/2006','luca')>
> [Logger - error] Caught SQL exception in query execution
> org.postgresql.util.PSQLException: ERROR: date/time field value out of
> range: "31/9/2006"
> org.postgresql.util.PSQLException: ERROR: date/time field value out of
> range: "31/9/2006"
>     at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>     at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>     at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>     at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>
>
> While in other tables it has worked with dates!
> The information about the table persona are the followings:
>
> gestione_personale=# \d persona;
>                  Table "public.persona"
>        Column       |         Type          | Modifiers
> --------------------+-----------------------+-----------
>  codice_fiscale     | character varying(20) | not null
>  nome               | character varying(12) |
>  cognome            | character varying(20) |
>  data_nascita       | date                  |
>  telefono           | character varying(20) |
>  cellulare          | character varying(20) |
>  fax                | character varying(20) |
>  indirizzo          | character varying(50) |
>  citta_nascita      | character varying(20) |
>  citta_residenza    | character varying(20) |
>  titolo_studio      | character varying(20) |
>  data_inserimento   | date                  |
>  utente_inserimento | character varying(20) |
>  data_modifica      | date                  |
>  utente_modifica    | character varying(20) |
> Indexes:
>     "persona_pkey" primary key, btree (codice_fiscale)
> Foreign-key constraints:
>     "$1" FOREIGN KEY (utente_inserimento) REFERENCES users(username)
>     "$2" FOREIGN KEY (utente_modifica) REFERENCES users(username)
>     "$3" FOREIGN KEY (titolo_studio) REFERENCES titolo_studio(titolo)
>     "$4" FOREIGN KEY (citta_residenza) REFERENCES citta(denominazione)
>     "$5" FOREIGN KEY (citta_nascita) REFERENCES citta(denominazione)
>
>
> Any idea?
> Thanks,
> Luca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate
>
>
>


pgsql-jdbc by date:

Previous
From: Luca Ferrari
Date:
Subject: Date time format out of range????
Next
From: Oliver Jowett
Date:
Subject: Re: confused about transactions and connection pools