I have a problem about convert a string to datetime.
in my database i have table with canceldate column.
that column have a empty row (like ' but not null ) and string (like '01-12-2004').
when i run query this message was show "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value."
if i use this query "convert(datetime,canceldate,105)" the empty row was convert to 1900-01-01 00:00:00.000.
i want convert that coloumn without change value of empty row.
View Complete Post