Selecting and replacing DATE fields with NULL values

Posted in: SQL
By dePoPo
Mar 11, 2009 - 9:24:47 AM
Digg this story!

Printer friendly page


Select date fields with NULL values:

SELECT * FROM Adressbook WHERE mydate IS NULL



Update fields with NULL values to have a default (and optionaly set NULL allowed to false after)


UPDATE    Adressbook
SET       mydate = ''
WHERE     (mydate IS NULL)



Visitor Comments


Leave a comment