Date in JDBC
От | Vernon Wu |
---|---|
Тема | Date in JDBC |
Дата | |
Msg-id | E9JMJWB083TS2XUS04WRSOQM2Z653X.3d0570f6@kimiko обсуждение исходный текст |
Ответы |
Re: Date in JDBC
|
Список | pgsql-jdbc |
I am first time using the date type in the jdbc or potgreSQL in general. One field of a DB table is the date type. In a query string I have: INSERT INTO account(firstname, status, userid,addr1,addr2,city,province,postcode,email,phone, cellphone, rdate, notes, lastname) VALUES ('John', 'n', 'rt', ' 340 Road', 'suite 201', 'mycity', 'wa', '98034', '34@32.com', '999-888-2222', '111-222-3333', 'Mon Jun 10 08:42:06 SGT 2002', 'NA', 'familyname') And I get the error message java.sql.SQLException: ERROR: Bad date external representation 'Mon Jun 10 08:4 2:06 SGT 2002'. I use the java.util.date to create a new date instance to convert to string. What is the right way to get the date right? Thanks in advance. Vernon
В списке pgsql-jdbc по дате отправления: