title: If there is empty date column then input current date and time
body: <p>If the date column is empty I want to input the current date and time using Oracle SQL.</p>
  <p>Given table,</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Login_Time</th>
  <th>Logout_Time</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">2021-08-20 09:57:00</td>
  <td>2021-08-20 10:30:00</td>
  </tr>
  <tr>
  <td style="text-align: left;">2021-08-20 10:00:00</td>
  <td></td>
  </tr>
  <tr>
  <td style="text-align: left;">2021-08-20 08:00:00</td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>In the Logout Time column is null then I have to input current time and date.</p>
  <p>So I have written the below query,</p>
  <pre><code>SELECT &quot;login_time&quot;, 
         CASE WHEN &quot;logout_time&quot; IS NULL THEN sysdate ELSE &quot;logout_time&quot; END AS &quot;logout_time&quot;
    FROM abc
  </code></pre>
  <p>I am not able to enter current time using above query. Can anyone help me with this</p>