org.postgresql.util.PSQLException

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

Samebug tips1

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>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web3472

  • 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
  • ERROR: could not read block 0 of relation 1663/38140/2659: Invalid argument
  • ERROR: null value in column "createdate" violates not-null constraint Detail: Failing row contains (218, Dataset, null, null, 2016-01-12 17:24:03.019, null, null, null, null, 217, null, f). Error Code: 0 Call: INSERT INTO DVOBJECT (CREATEDATE
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    131 times, 1 month ago
    3 times, 7 months ago
    25 times, 7 months ago
    4 times, 9 months ago
    91 more bugmates