org.postgresql.util.PSQLException: ERROR: error in argument for $3: could not parse string "2016-7-17 -4:0:0" as date

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
via stackoverflow.com by Unknown author

Upgrade the database driver to the latest and check.

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.3-1101-jdbc41</version>
</dependency>

Replace version with the latest driver version.

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via GitHub by samlotti2
, 1 year ago
ERROR: error in argument for $3: could not parse string "2016-7-17 -4:0:0" as date
via Stack Overflow by Aarish
, 11 months ago
ERROR: function array_remove(text[], character varying) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 60
via Stack Overflow by displayname
, 2 months ago
ERROR: null value in column "created" violates not-null constraint Detail: Failing row contains (1, null, null, null, $2a$10$0GEFgVryvwG3Dv5LN1tg6evPpl4wQ9uJOWiMKMyZq8HVQXCMRt.kS, null, test).
via GitHub by BorisDomajnko
, 1 year ago
ERROR: relation "uca_metadata.prop" does not exist
via Stack Overflow by Chitresh
, 2 years ago
ERROR: null value in column "customer_ui_id" violates not-null constraint
org.postgresql.util.PSQLException: ERROR: error in argument for $3: could not parse string "2016-7-17 -4:0:0" as date
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155)
at com.hapticapps.cockroach_sample.BasicSample.main(BasicSample.java:38)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.