Microsoft SQL Server 2005 Best Practices

How to apply ISNULL with datetime column?

 

ISNULL is a convenient default setter for a string column usually to empty string ''. With a datetime column you have to pick a characteristic date like the following:

SELECT BirthDate=ISNULL(BirthDate, '1900-01-01') from HumanResources.Employee


 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page