How to convert Null Date into Blank?

Question

I have a table which I'd like to convert Null Date (my date format i.e 2014-02-12) to blank string but an error occurs whenever I do IsNull, I have mysql. Is there away to do it with isnull?

Do you have a code sample, and what is the data type of the field? Also, are you talking about converting the *output* of a query, or the data in the field itself? — Andrew Barber, May 13 '14 at 15:36

score 2 · Answer 1 · answered May 13 '14 at 15:39

2

Try this:

SELECT ISNULL(CONVERT(VARCHAR, date_field), '')
FROM table_name

answered May 13 '14 at 15:39

Isaac Kleinman

3,994
3
31
35

score 1 · Answer 2 · answered May 13 '14 at 15:34

1

MySQL:

 SELECT ISNULL(CAST(date_value AS char),'')

or

 SELECT ISNULL(DATE_FORMAT(date_value , '%d %m %Y'),'')

SQL SERVER:

 SELECT ISNULL(CAST(date_value AS VARCHAR(20)),'')

answered May 13 '14 at 15:34

T McKeown

12,971
1
25
32

the question state's it's mysql. – T McKeown May 13 '14 at 15:36
1

I think Kermit realized that just seconds after posting the comment. heh – Andrew Barber May 13 '14 at 15:37
thanks guys, also, I have an issue because my date column is in temporary table? I tried ISNULL(CONVERT (VARCHAR(20), #a.date), ' ') but it can't pop up. Does it not apply for temp table? – user3597281 May 13 '14 at 15:40
try the other mysql ways first, shouldn't matter if it's in a temp table or not. – T McKeown May 13 '14 at 15:40

How to convert Null Date into Blank?

2 Answers2