smallDateTime Null Value Problem

[smichener]

Hello All,

I'm trying to run a query in Query Analyzer in which if a smalldatetime field isNull, I want ot to come back blank. Bu when I use - ISNULL(a.terminationDate, '') - all null values are returned as 1900-01-01 00:00:00. Does anyone know how to deal with this?

Thank You

Steve

 

[vidru]

You'd have to convert the date to a string in order to return an empty string for the nulls, like this:

ISNULL(CONVERT(VARCHAR(20),A.TerminationDate,20),'')

-dave

 

[SQLBill]

DATETIME and SMALLDATETIME have a 'built-in' default. There isn't ever a NULL entry for those data types.

-SQLBill

 

[smichener]

Thank you very much Vidru, it worked like a charm.

Steve

 

[markinro]

Well, how come I can specify 'Null' in my table design ?

When I insert records, I clearly have nulls in the date fields.