I'm trying to return the SQL date time value of '1900-01-01 00:00:00.000' as NULL. I'm using the code below. But, instead, it's returning 01/01/1900.
True, I do want this date format of mm/dd/yyyy, if the date is a "real" date and not 01/01/1900. But, I want the date returned as NULL, if it is 01/01/1900.
What's wrong with my syntax?
ISNULL(CONVERT(VARCHAR(10),RM20101.DUEDATE,101),'') as [DUE DATE]
Open in new window
Have you tested the column to make sure that the value is NULL and not the epoch date?