check null value datetime column sql server code example

Example: show if date is nul sql

SELECT * FROM yourtable WHERE yourdatecolumn IS NULL