CODEWITHSUNDEEP
javajsonpostgresqlconcordion
Maksym Rybalkin
Maksym Rybalkin

Reputation: 533

PostgresSQL jsonb column - problem with "."

I'm trying to add the value to my table with a jsonb column:

{"prefId": 1, "prefType": "PREF", "date": "23.07.2020"}

But I'm getting an error:

ERROR: invalid input syntax for type json
  Detail: Token "." is invalid.
  Where: JSON data, line 1: 23.07....

What is the problem and how to solve it?

Upvotes: 0

Views: 78

Answers (1)

Asadbek Fayzullaev
Asadbek Fayzullaev

Reputation: 27

There is an error in date format. Try 23/07/2020 or 23-07-2020

Upvotes: 1

Related Questions