Sql display null date as blank

I wouldn't necessarily recommend this approach, though. You might be better to use ZN around the date field. That will replace the NULL value with a "0". The characters after "THEN" are two single quotes, not one double quote. That formula assumes there are only 2 possible values in the data field: NULL and a valid date. If there are other possible values you need to test for them as well.

Now here is my field has Date data type and by default it shows me Is there anyway to replace date with blank without changing datatype to string. This gives you blank value but your date field will be converted to string. Actually I am using tableau 9 and dateparse function is not there. It is introduce in tableau Thanks tushar for your reply and I tried with your solution, but gives me default date i.

I think, for date datatype it wont possible to replace default date with blank. I can't believe this worked! Almost too easy! That means that you cannot mix string '' and decimal data in the same column.

This is why it's converting your '' to 0. Jonathan AC Roberts. You're confusing a SQL table with a spreadsheet. They are totally different things.

We don't do display formatting in the database; that's passed to what we call a presentation layer in the host language. Essentially, your problem is you haven't yet learned what a tiered architecture is or what a strongly typed language is. I am getting the answer directly without any conversion in sql server My question is different version of sql server behaves differently??

Thom A. Make you insert real nulls not strings, then the db will store a null. I was having the same issue this morning. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years ago. Active 6 months ago. Viewed k times. I mean, if there is no value inserted, the default value should be null, empty, etc. Improve this question. The solution is in-fact a workaround or a quick fix than a total solution, since a blank date can be either a NULL or However, converting the date into a string does relieve us from showing irrelevant data to our clients.

Date and Time are not character values and therefore, you must handle it carefully. Please enable JavaScript to view this page properly.