Devart Forums

I have a table with a date field which can be null, such a table now has rows with valid date values and null values too. I need to build a query in C# to get all rows that have null values in the date field but I have not been able to achieve it. It is something like this:

strQuery = "SELECT * FROM sources WHERE src_date = NULL ORDER BY src_name"

I have tried using PgSqlTimeStamp.Null without success.
What is the correct way to write this query statement?

With respect,
Jorge Maldonado

Please use the following query:
"SELECT * FROM sources WHERE src_date IS NULL ORDER BY src_name" .

I appreciate your answer.
So, would PgSqlTimeStamp.Null be useful to set a NULL value to a date field?

Regards,
Jorge Maldonado

We will investigate the possibility of using PgSqlTimeStamp.Null in this case and post here about the results.

By default, PostgreSQL does not allow using the NULL parameter (the expression = NULL clause). Please refer to http://www.postgresql.org/docs/current/ ... rison.html.