Date time format out of range????

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Date time format out of range????
Дата
Msg-id 200610311118.55852.fluca1978@infinito.it
обсуждение исходный текст
Ответы Re: Date time format out of range????
Список pgsql-jdbc
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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: confused about transactions and connection pools
Следующее
От: Tom Arthurs
Дата:
Сообщение: Re: Date time format out of range????