Hi developers in this post am going to share with you, how I solved the above PostgreSQL error. As small as it is, I believe any error is annoying for someone like me who is just trying to understand PostgreSQL as a beginner and getting familiarizing with its inbuilt functions.

So this is what happened, I wanted to pick the current database date and wanted the date to display in ‘YYYY-MM-DD’ format. just after running the select query I got an SQL state: 42883 error.

--

--

Salifyanji Taala

Salifyanji Taala

Wife, Software Developer and love learning