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 по дате отправления: