I'm using postgresql and getting this sql error:
org.postgresql.util.PSQLException: ERROR: invalid input syntax for type date: "\N"
Here is my code:
SELECT * FROM person WHERE person.dob = '\N' OR person.dob = '1994-01-16';
How can I allow Null values? so what should I add to this SQL statement?
Try this following code:
SELECT * FROM person WHERE person.dob is null OR person.dob = '1994-01-16';
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments