title: Replacing specific date with a empty value in Oracle denodo
body: <p>I have a view where I am selecting a date column and reading it as a local date in denodo. In my column, I have a date '00-Jan-1900' like this which is giving issue so I wanted to replace this with empty.
  When I run this query, I get results as shown in the table2. But what I want is just an empty record in place of this date and looking like TABLE3.</p>
  <p>Query:</p>
  <pre><code>select
  to_localdate('dd-MM-yyyy', substring(replace(&quot;DATE&quot;, '00-Jan-1900', ''), 0, 10)) AS dtm
  from XX
  </code></pre>
  <p>Table1:</p>
  <pre><code>DATE
  22-Dec-2016
  00-Jan-1900
  30-Sep-2014
  </code></pre>
  <p>After replacing the date i get</p>
  <p>Table2:</p>
  <pre><code>DATE
  0201-12-22
  
  0201-09-30
  </code></pre>
  <p>Is there a way i get output table like this?</p>
  <p>TABLE3:
  DATE
  22-Dec-2016</p>
  <pre><code>30-Sep-2014
  </code></pre>