| 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 |
|